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

    set analysis MonthName problem

      Hi,

       

      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:

       

      num(sum({$<MonthYear={$(=MonthName(max(MonthYear)))}>}Sales),'#.##0,00') 

       

       

      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?