
Contributor III
2019-01-08
12:12 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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,059 Views
1 Reply

MVP
2019-01-08
12:16 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
To round... use this =Round(Exp, 0.01)... but this isn't perfect as Round comes with Rounding Errors
1,053 Views
