Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
RangeSum(Above(SUM({<ClearUpCommittedTime_IPTHO=-{0}>}ActualIncidents),0,RowNo()))
/
sum(TOTAL {<ClearUpCommittedTime_IPTHO=-{0}>}ActualIncidents)