Post

2 followers Follow
1
Avatar

Handle Rollover of 999999 Value from Manual Measure

Create Manual Measure to capture daily Accumulated Instrument Value.
Create Calculated Measure:
Conditional.If
(
(Manual Accumulated Measure (kWh).Value - Manual Accumulated Measure (kWh)[-1].Value) < 0,
(999999 - Manual Accumulated Measure (kWh)[-1].Value) + Manual Accumulated Measure (kWh).Value,
Manual Accumulated Measure (kWh).Value - Manual Accumulated Measure (kWh)[-1].Value
)
This will give a used kWh per time bucket

Braam Venter

Please sign in to leave a comment.