Accounting 2.0 - How to set the formula with Operators (If)
Question : My Unit price is calculated using formula = d_UDF_UP * d_UDF_W * d_UDF_H. But sometimes the value of UDF is empty, it causes the Unit price becomes 0.
How can I set the Formula, so that when the value of UDF is null, it will be counted as 1
Use the Operators (If) : Conditional Operator
Syntax : If (Condition, whenTrue, whenFalse)
Apply this operators ‘If’ with your UDF condition.
if( d_UDF_UP = 0, 1, d_UDF_UP ) * if( d_UDF_W = 0, 1, d_UDF_W ) * if( d_UDF_H= 0, 1, d_UDF_H)
Example of the result when one of the UDF is empty in value:
By : Lay Swan 190207, P190208
|AutoCount Accounting 2.0
|AutoCount Accounting 1.8 / 1.9
|AutoCount On The Go
|AutoCount Accounting Plug-In Documentations