Discussions

Expand all | Collapse all

Formula for numeric field "" if null

  • 1.  Formula for numeric field "" if null

    Posted 01-13-2017 23:58
    Hello Everyone,

    I'm trying to write a formula where if my price field is left empty the default list price is inserted.



    This SELL PRICE (currency field) is in the LINE ITEM table where the lookup on the PRODUCTS table where DEFAULT PRICE(currency field)  is located.

    In Salesforce it was something like " if null = default price"..........................

     


  • 2.  RE: Formula for numeric field "" if null

    Posted 01-14-2017 00:05
    It depends on the field properties of [Default Price].

    If Treat blank values as 0 in calculation is checked:

    If([Default Price]=0,then statement,else statement)

    If Treat blank values as 0 in calculation is not checked:

    If(IsNull([Default Price]),then statement,else statement)


  • 3.  RE: Formula for numeric field "" if null

    Posted 01-14-2017 00:37
    Thanks I will try the second option


  • 4.  RE: Formula for numeric field "" if null

    Posted 01-16-2017 00:17
    Hey dwhave
    I'm getting this message:
    Please check the syntax of your entire formula. Possible culprits are a mismatched set of parentheses, missing quotes, or an extra bracket.

    This is my formula .
    The DNprice field is a look up in  the PRODUCT TABLE

    If(IsNull([Product - DN Price])


  • 5.  RE: Formula for numeric field "" if null

    Posted 01-16-2017 14:33
    Another closing parenthesis:   If(IsNull([Product - DN Price]))