Forum Discussion
Solved
Capping a cumulative total
Hi All, I have a machinery table, where downtime has a cost per minute. So, as per below, Event 1 the machinery was down for 100 minutes at a per minute rate of £65.00. These are all in my tabl...
@Daviejoe, if the rate is the same for everyone
New Measurement: Sum(Table[No Minimum]) * max(Table[Rate])
if you don't
New measurement: sumX(Table, Table[Mins Not]*Table[Rate])
@Daviejoe, if the rate is the same for everyone
New Measurement: Sum(Table[No Minimum]) * max(Table[Rate])
if you don't
New measurement: sumX(Table, Table[Mins Not]*Table[Rate])
Thanks amitchandak
Each event will need to be capped at £50,000 so I need do that at a row level and also when I roll up all the events into one KPI.