Simple Set Analysis Question

[#1]

I am trying to find the sum of all charges for the last date posted regardless of any selections.  Currently I am working with this formula and striking out.  Does anyone have any tips?

=Sum({1<[Charges.POST_DATE]={$(=Max(Charges.POST_DATE))}>} [Charges.CHG_AMT])

Thanks!

[#2]

Looks like that should work. 

Do you have a sample data set you can pass on?

[#3]

I added it to my original message

Thanks!

[#4 · Accepted solution]

Oh sorry I didn't see it at first.

Looks like the set statement for POST_DATE doesn't recognized the date value properly so I forced the value with the following statement.

Sum({<POST_DATE= {'$(=Date(MAX({1}POST_DATE),'YYYY-MM-DD'))'}>}CHG_AMT)

Hope this helps.

[#5]

No you didn't miss it, I added it after you asked for the data!

It worked perfectly!

THANK YOU SO MUCH!