AnsweredAssumed Answered

Calculate Pump stop and Pump start date

Question asked by DURGAMALLESWARARAO on Nov 11, 2020
Latest reply on Nov 13, 2020 by ChristophRose

Hi,

Gabriel Michaud-Verreault  Sebastien Raposo

 

I would like to know when Pump started and Pump stopped so I am using below calculation. 

 

Pump start date: if 'PumpStatus' ="Stop" then Exit() else if PrevVal('PumpStatus','*' ) = "Stop" and 'PumpStatus'="Running" then TimeStamp('PumpStatus') else NoOutput()

 

I can find pump start date and pump stop date for most number of pumps but few are never started/stopped like below. Business would like to know when pump initially started or stopped. Kindly let me know how can I fix it. 

 

Pumpstatus: 0- Stop, 1- Running

 

Pump stop date: if 'PumpStatus' ="Running" then Exit() else if PrevVal('PumpStatus','*' ) = "Running" and 'PumpStatus'="Stop" then TimeStamp('PumpStatus') else NoOutput()

 

Thanks,

Mallesh

Outcomes