percentage in report

[Ravi Kumar]

dear all,

I have entered below expression to show percentage in my report , but unfortunately it is not displaying.

=[Sum Of Leave(Hrs)]/([Sum Of Leave(Hrs)]+[Sum Of LOP(Hrs)]+[Sum Of Absent(Hrs)]+[Sum Of OT(Hrs)])

can anyone help where i am wrong?

 

[Gasman]

I *think* if any of them are Null, then that will happen.
Surround each with the NZ() function and try that.

HTH

 

[arnelgp]

use the calculation on the Sum textboxes.

 

[Ravi Kumar]

use the calculation on the Sum textboxes.

=Nz("",[Sum Of Leave(Hrs)])/Nz("",([Sum Of Leave(Hrs)]+[Sum Of LOP(Hrs)]+[Sum Of Absent(Hrs)]+[Sum Of OT(Hrs)]))

Like this??(not working)

 

[Gasman]

Now I do not know if Null is causing the problem, but you do not have the correct syntax for NZ() to start with.

Also if you are doing math on the controls, do you not think zero would be a better option rather than space?

 

[Ravi Kumar]

I replaced the empty cells with Zero & now it is working. Thank you for your tip.

 

[Gasman]

That is what the NZ() function is meant to do?