4 Replies Latest reply: Apr 3, 2018 3:35 AM by Massimo Favaro RSS

    Set analysis: sum if date before today

    Massimo Favaro

      Hello everyone,

      I'm trying to create a misure based on the current date. I'd like to sum the differences between two dates, based on the finish date that must be not after today.

      So, I'd like to achieve something like:

      SUM({<FinishDate <= {Today()}>}               INTERVAL(Finishdate - StartDate, 'd'))

      Obviously the formula is wrong, how could I achieve that?

      Many thanks