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

    last day - with any selection

      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