Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
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