2 Replies Latest reply: Feb 7, 2013 4:59 AM by tine theunis RSS

    set analysis MonthName problem



      I have a set analysis problem, I want to see the sum of sales of the max month and year and later max monthyear -1. I used these set analysis expressions:


      max(MonthYear)  gives 41306 so i used MonthName(max(MonthYear))  which gives me the text: feb 2013


      But when I use it to calculatie the sum of the sales I don't get a result:





      There is no problem in my data because num(sum({$<MonthYear={'feb 2013'}>}Sales),'#.##0,00')  gives me a result.

      Does anyone know what's wrong with my syntax?