5 Replies Latest reply on Aug 6, 2018 8:12 AM by André Åsheim

    Event - weighted totalizer for specific time range

    STELLA

      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