0 Replies Latest reply: Feb 4, 2013 8:35 AM by jörn kunz RSS

    YTD Formula with if expression

      Hello together,

       

      i have a problem by create a formula YTD include an if expression.

       

      count({<Year={$(vMaxYear)},Date={'<=$(vMaxDate)'},Month=, (if((EffektwertSumme<='150,00' AND EffektwertSumme<='150'))>} [Einkaufsbeleg])

       

      Nothing will display!

       

      Could you help me, what is wrong with the formula?