Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mkamal
New Contributor

How to Round to decimal places in Count Set analysis

 

 

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])

1 Reply

Re: How to Round to decimal places in Count Set analysis

To round... use this =Round(Exp, 0.01)... but this isn't perfect as Round comes with Rounding Errors