Set Analysis not working

[suvechha_b]

Hi All,

Please kindly assist me in the set analysis.

I want to count the Claims Number depending on the condition, [Partner Grouping Name]='Personal & Commercial'

and Max(CLAIMS_CAPTURED_MONTH_NAME).

Count({$<[Partner Grouping Name]='Personal & Commercial',CLAIMS_CAPTURED_MONTH_NAME={"$(=(Max(CLAIMS_CAPTURED_MONTH_NAME)))"}>}[Claims Captured Claim Number])

Thanks,Suvechha

[DavidM · Accepted solution]

you're missing {} in Personal&Commercial:

Count({$<[Partner Grouping Name]={'Personal & Commercial'},CLAIMS_CAPTURED_MONTH_NAME={"$(=(Max(CLAIMS_CAPTURED_MONTH_NAME)))"}>}[Claims Captured Claim Number])