Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
mkamal
Contributor III
Contributor III

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
sunny_talwar

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