2 Replies Latest reply: Feb 13, 2018 7:17 AM by Sunny Talwar RSS

    Syntax MonthYear

    Antonio Forino

      Hi Guys!

      i have build the formula below that is working perfectly.

      BTW i have to create another one where the SurgeryMonthYear should be the MonthYear minus 12 months. Anyone knows which is the right syntax?



      =Sum({<SurgeryMonthYear={$(=concat(chr(39) & MonthYear & chr(39),',') )},MonthYear=,Day=,Year=,Month=,Quarter=>}[Surgical Procedures WI])