Could you please clarify on what you are trying achive. As per your problem statement you are calculating from midnight to 9 pm (yesterday) and midnight to 9 pm (Today). If shift is from yesterday 9 pm to today 9 pm then why you want to reset at 10 pm.
My daily O2 PRODUCTION Automatically reset on 10 pm ,i dont want to reset it.
1 of 1 people found this helpful
From your equation: IF Hour('*') <= 21 THEN
Since you are only looking at the hour, your equation will totalize until 9:59:59 PM; at 10:00:00 PM, the hour will be 22 and the 'ELSE' portion of your calculation will be used.
If you want to have the total reset AT 9:00 PM, change your '21' to a '20'; that will then use a total up to 8:59:59 PM, with a reset at 9:00:00 PM.
Do you want a running total, meaning the value is never reset, but instead always incremented with the new total?