4 Replies Latest reply: Apr 3, 2018 2:50 AM by Pascal Dijkshoorn RSS

    Yesterday in set analysis

    Pascal Dijkshoorn

      Hello again

       

      In a formula, i want to sum up some measures from the day before the date that is displayed as a dimension. I am using the following formula to calculate the current date. Also the date field is called: Activity_Date

       

      sum(frac(EXTRA_TIME_NEXT_DATE))

       

      I have already tried many formulas that are on this forum. Also i tried setting a variable for yesterday and use that variable in the set analysis. However i did not get it to work yet.