Stop Rounding 1

[loveyoursite]

CRV10 - I have a turnover formula that is rounding up but I do not want it to. The field format for rounding is set to .01

If {#Term By Dept} = 0 Then
0
Else
If {@Avg Active for full period by Dept} = 0 then
100
else
Truncate (({#Term By Dept} / {@Avg Active for full period by Dept}) * 100,2)
=======================================
Here is a breakdown:

Running Total: # Term By Dept
{EMPLOYEE.TERM_DATE} >={?Start Date} and
{EMPLOYEE.TERM_DATE} <={?Stop Date}

Formula: Avg Active for full period by Dept
({#Active Beginning of Period By Dept} + {#Active End of Period By Dept}) / 2

Avg Active for full period by Dept is set to no decimal and rounding is set to 1
=======================
End Result:

Avg Active for full
period by dept # Term By Dept Turnover
23 4 17.77%

The turnover should be 17.39%. My formula is treating the "23" as though it were not rounded, 22.50

I would appreciate any assistance. I'm sure I must have something conflicting with something else. Thanks!

 

[lbass]

Change your formula to:

round(({#Active Beginning of Period By Dept} + {#Active End of Period By Dept}) / 2)

-LB

 

[loveyoursite]

That was the solution. Thanks so much LB!!!