2 Replies Latest reply: Apr 16, 2018 11:28 PM by Pankaj Sharma RSS

    Calculate sum of variances for last quarter max month

    Pankaj Sharma

      Hi there,


      I want to create a calculation which sum last moth of previous quarter.


      Create calculation as below but it is not working might be I have variable contains another variable inside. Given below field and variables.

      MonthYear = Month(business_date)&Year(business_date)


      Previous_QTD_Actionable_Variances=    Sum({$<MonthYear={"$(vPreviousQuarterMaxMonth)"}>} ipt_actionable_total)


      vPreviousQuarterMaxMonth=     MONTH(QuarterStart(vMaxBusinessDate)-2)&YEAR(QuarterStart(vMaxBusinessDate)-2)


      vMaxBusinessDate=      =DATE(MAX(business_date))


      Really appreciate, if someone can help.