Set Analysis with Variable

[#1]

I have created a variable vDateMax = num(max(TNA_DATE)) to return the max date of date range selected.

I would like a text object to display the sum of ASSETS where TNA_DATE=vDateMax. This is my expression:

=Num(sum({$<TNA_DATE={$(vDateMax)},CONSULTANT_FIRM_ID={*}>} ASSET_ACCOUNT_TNA),'$ #,##0')

Can anyone help; I'm getting "Error in set modifier ad hoc element list: ',' or ')' expected"

[Colin-Albert]

Try this, you need to format the variable not the field being compared.

=Num(sum({$ <TNA_DATE={" $(= date($(vDateMax),'MM/DD/YYYY,)"}, CONSULTANT_FIRM_ID= >} ASSET_ACCOUNT_TNA),'$ #,##0')

[#3]

Figured it out finally. Gave up on using the on-the-fly variable (vDateMax), and used the existing column TNA_DATE instead

=num(Sum({$<CONSULTANT_FIRM_ID={*},TNA_DATE={$(=max(TNA_DATE))}>}ASSET_ACCOUNT_TNA),'$ #,##0')

[#4]

thank you - i already use this site all the time