Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Community,
I have an hourly report where I want to calculate the total value starting from a specific hour. My data looks like this:
For each day I want to have a KPI that sums up the total value starting from 6 o'clock. I checked for RangeSum() but I cannot get the right values in my table.
I hope someone can support me.
Thank you very much in advance!
@vkal12 try below
rangesum(above(Sum({<Hours={">=6"}>} Value),0,RowNo())) + Sum({<Hours={"<6"}>}Value)
May be try this
Sum({$<Hour={">=6"}>} Value)
Hi Chaty4u,
of course this formula works but I need to have the same table as mentioned in my question. This means that in each additional row I need to have this kind of rolling sum.
Do you have another idea?
@vkal12 try below
rangesum(above(Sum({<Hours={">=6"}>} Value),0,RowNo())) + Sum({<Hours={"<6"}>}Value)
Thank you for this formular - it works perfectly!