11 Replies Latest reply: Feb 11, 2016 4:36 AM by Sunny Talwar RSS

    Syntax error

    Prasanta Kumar

      Hi,

       

      I am writing the below syntax to get total sum but not getting proper result.

       

      Please advise what wrong i am doing here.

       

       

      sum({<fMonthCD={$(=max(fMonthCD)-1),$(fReportMetricKeyId)={1}}>}fCallAnsweredBeforeThreshold)

       

      fmonthCD is in format like "201507", "201508"... so on and under column i have values like 1, 2, 3.....

       

      i want to get the sum for max of (fmonthCD).

       

      Regards,

      Prasanta