Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey, I need to round the output of formula. Right now I need it count employees with a FTE greater than 1.2 but right it is including exmployees with 1.2 I suspect there are some employees with a value of 1.20000001 . How do I round to two decimal places. I tried Num ( expression, ##.00) but that did not work.
=Count({<[Employee] = {"=
(
Sum(
Aggr(
(sum([Emp FTE Calc] )/(($(vCountOfDays)*(40/7)))
)
,[Employee]
)
)
) >1.20"}>} Distinct [Emp Name Nbr])
To round... use this =Round(Exp, 0.01)... but this isn't perfect as Round comes with Rounding Errors