6 Replies Latest reply: Aug 10, 2015 2:14 AM by Agathe Fischer RSS

    last day - with any selection

    Agathe Fischer

      Hi all,

       

      I have the following formula in textfield that should give the number of DimensionToCount on the day that is before the selected day (or month):

       

      count(if (InDay (Date, vDateToAnalyse, -1), DimensionToCount))

       

      vDateToAnalyse:  DayName (max(Date), 0)

       

      That returns the correct number if I have no selection. But if I choose another day and want to see the Value of the day before, I get "0" because of the selection. 

       

      I thought something like that could be the solution: count({1}if (InDay (Date, vDateToAnalyse, -1), DimensionToCount))

       

      But that Returns the wrong value. Does anyone have an idea how to solve this problem?

       

      Many thanks in advance

       

      Agathe