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
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)
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)