2 Replies Latest reply: Feb 6, 2013 8:55 AM by Alessandro Saccone RSS

    Year to Date with an if Expression

      Hello together,


      i have a problem and search for the solution.


      I want so show the the YTD figures, the column YTD works, but the YTD<150 doesen't works.


      No of OrdersYTD<150€YTD <150
      count([DISTINCT [Einkaufsbeleg])count({year={$(vMaxYear)}, Date = {'<$(vMaxDate)'}, Month=>}[Einkaufsbeleg])count(DISTINCT if((EffektivwertSumme>'150,00' AND EffektivwertSumme> '150') [Einkaufsbeleg]))count({year={$(vMaxYear)},Date={'<$(vMaxDate)'}, Month=>} if((EffektivwertSumme>'150,00' AND EffektivwertSummer<'150), [Einkaufsbeleg]))


      If you see the bold characters, there are problem with the if expression. How can include the if expression in the complete formula.


      Thank you for you hints.


      Greets Nikolaus80