Formula for numeric field "" if null
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 th...
Forum Discussion
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])
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])