Syntax error

[#1]

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

[#2]

i can calculate max(fmonthCD). see the screen shot.

but dont know why its not returning a result while using max inside my set analysis

[sunny_talwar]

Would you be able to share a sample of your application to take a look at?