A1.66 : 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
Answer :
Use the Operators (If) : Conditional Operator
Syntax : If (Condition, whenTrue, whenFalse)
Apply this operators ‘If’ with your UDF condition.
Formula :
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:
--Source from AutoCount Wiki --
Related Articles
A3.187 : Formula: How to set up formula for Baitulmal deduction?
Question : Formula: How to set up formula for Baitulmal deduction? Answer 1) Go to Tools > General Maintenance > Deduction> Add New > Baitulmal 2) Key the formula as below. Save after done. 3) Now formula for Baitulmal is set. --Source from AutoCount ...A3.188 : Formula: How to set lateness formula using IF ELSE function in deduction?
Question : How to set lateness formula using IF ELSE function in deduction? Answer 1) Go to Tools > Deduction> 2) Click on Add New button 3) Maintain Deduction Code, Description and determine the statutory setting. Then click on Formula to set your ...A3.185 : How to set lateness formula in deduction?
Question : How to set lateness formula in deduction? Scenario I wish to set lateness deduction formula in hourly rate based on employee’s basic rate. Answer : 1) Go to Tools > General maintenance > Deduction 2) Click on Add New 3) Fill in Code, ...A3.97 : How to set formula in claim type example for mileage?
Question : How to set formula in claim type example for mileage? Answer : 1) Go to Tools > Claim Type 2) Click on Add New button to add new claim type for Mileage Claim. 3) Key in the claim code and description then click on Add Detail button to add ...UBSA1.20 : Access UBS (Accounting): How to set formula to calculate quantity
EnvironmentAccess UBS ( Accounting) SolutionTo set formula to calculate quantity: UOM : 1 TIN = 500ML UOM : 2 TIN = 500ML x 2 QTY = 1 LITRE When cursor reaches Quantity, hit the arrow down key on the keyboard to pull out the dialog box Determine ...