Calculated Field Doubt

[paulcherianc]

Hi ..

Where am i wrong in this formula. I am not getting the exact results.

Expr1: [Total C]+Nz([Final Export]![Company Provided Social & Healthy Security],0)+Nz([Final Export]![Employers Additional Charges (Above 20%)],0)*[ExchRate]+Nz([Mobilization Demobilization Cost]+Nz([Final Export]![Furniture Allowance],0)/36+Nz([Final Export]![Visa Cost]/12))

 

[JHB]

Expr1: [Total C]+Nz([Final Export]![Company Provided Social & Healthy Security],0)+Nz([Final Export]![Employers Additional Charges (Above 20%)],0)*[ExchRate]+Nz([Mobilization Demobilization Cost]+Nz([Final Export]![Furniture Allowance],0)/36+Nz([Final Export]![Visa Cost]/12))

Looking at what you else have set up it seems as you got "lost" in the NZ function.

Expr1: [Total C]+Nz([Final Export]![Company Provided Social & Healthy Security],0)+Nz([Final Export]![Employers Additional Charges (Above 20%)],0)*[ExchRate]+Nz([Mobilization Demobilization Cost],0)+Nz([Final Export]![Furniture Allowance],0)/36+Nz([Final Export]![Visa Cost],0)/12)

 

[paulcherianc]

Many Thanks!