I have a tag " Pump_On_IND" that is == 1 whenever the pump is running.
I am trying to implement this formula into my report designer:
Total Gallons Flowed = "Pump_On_IND" * 287.5
In these reports, each row is a unique batch. I would like for this to calculate the gallons flowed for each batch, and put it in a column in my report designer.
I achieved using the DurationOn aggregate, but when I used it in a column, it reported the entire start date to end date total (same number in every row for that column). It did not separate it by batch.
Could anyone point me in the right direction here?