To follow on from my previous post I am having an issue with a culmative total line that is exceeding 100%
(above(total sum({<ClearUpCommittedTime_IPTHO=-{0}>}ActualIncidents), 1, rowno(Total)))
/
sum({<ClearUpCommittedTime_IPTHO=-{0}>}total ActualIncidents)
This is the existing formula in place which I didn't write, Is there an easier way of writing this?
The ClearUpCommittedTime_IPTHO is a integer field with seconds of time so 2 Minutes is showing as 120.
ActualIncidents is 1 or 0
