AnsweredAssumed Answered

Event - weighted totalizer for specific time range

Question asked by STELLA on Aug 1, 2018
Latest reply on Aug 6, 2018 by André Åsheim

Hi everyone,

 

I have been trying to create an event-weighted totalizer for airflow real time data starting from a specific date. I have watched the video on how to create an event-weighted totalizer MTD or YTD but I would like it to begin on a specific date and not to reset once it hits the month/year mark.

The calculation that was shown on the video was

And I was wondering if for example I wanted results since 10/17/17, I could replace these numbers into the equation as follows:

If (BadVal(Production)) = TRUE

then

NoOutput()

Else

If ((Day('*')<>Day(PrevEvent('Inc Yearly Running Total','*')) and Day('*')=17 and Monthly('*')=10 and Year('*')=2017) or Production ="Pt Created")

then

Production

Else

Production + 'Inc Yearly Running Total'

 

Any ideas?

 

Thank you,

 

Stella

Outcomes