3 Replies Latest reply: Jan 7, 2012 2:47 PM by Miguel Angel Baeyens de Arce RSS

    Set analysis question

    Henco van Ee

      Hi all,

       

      At this moment I use the following expression: sum({1}if(MonthYear=num(Month(Today())) &'-'& Year(Today()), Transamount)).

      This gives me the oppurtinity to show the revenue for the current month. The problem is that it gives me to much, so I want to put this in a set analysis.

      Can anyone give me the right expression?

       

      Kind regards,

      Henco