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
If ((Day('*')<>Day(PrevEvent('Inc Yearly Running Total','*')) and Day('*')=17 and Monthly('*')=10 and Year('*')=2017) or Production ="Pt Created")
Production + 'Inc Yearly Running Total'