Max Quarter Spend

[alis2063]

I am trying to calculate the Max Quarter Amount  based on below  calculation but it is throwing  Error,

NUM(sum({$<NCRQuarter={$(vMaxQuarter)}>} Actual_Amount), '###')

Where

vMaxQuarter='Q'&Max(ceil(month(NCRIdentificationDate)/3))

&

NCRQuarter='Q'&CEIL( MONTH(NCRIdentificationDate) / 3)

Please help.

[sunny_talwar]

May be try this

NUM(sum({$<NCRQuarter={'$(=vMaxQuarter)'}>} Actual_Amount), '###')

[alis2063]

Hi Sunny,

Thanks for reply.

But it is still showing error as 'error in set modifier ad hoc element list'

[sunny_talwar · Accepted solution]

Try with double quotes

NUM(sum({$<NCRQuarter={"$(=vMaxQuarter)"}>} Actual_Amount), '###')

[alis2063]

THANKS for help dear..