0 Replies Latest reply: Apr 15, 2018 9:42 PM by Heng Hoong Cheang RSS

    Help with Set analysis Month Year-to-Date, with date not provided

    Heng Hoong Cheang

      Hi,

       

      Im trying to get the year to date table presented in month, I need the month name and budget data to be shown in the table.

       

      However, date is not provided for the budget data only the month and the year available, so that budget data could not be linked to the date created from master calendar. I could not figure out the solution to get it solved. The script below doesn't work, any help would be very much appreciated.

       

      =sum({<Month={">=$(=Num(Month(Yearstart(Date))))<=$(=Num(Month(Max(Date)))"}, Year= {'$(=Year(Date))'}>}Budget)