Sum and Filtering using dates

[#1]

I am attempting to create an expression that allows me to sum a value based on the max date. I am able to successfully get this to work with the following:

BS Fiscal Year Column = 2014

Sum({$<"BS Fiscal Year"=

{$(=max("BS Fiscal Year"))}>}

[Total Adjusted Fair Value])

When attempting to do the same, but using a date formatted MM/DD/YYYY

BS Date Column = 12/31/14

Sum({$<"BS Date"=

{$(=max("BS Date"))}>}

[Total Adjusted Fair Value])

I am not getting any results.  Any idea why?

[sunny_talwar]

Try this instead:

=Sum({$<[BS Date]= {"$(=Date(Max([BS Date]), 'DD/MM/YYYY'))"}>} [Total Adjusted Fair Value])

HTH

Best,

Sunny

[#3]

Sunny,

Thanks for the prompt reply, but this did not work.

[sunny_talwar · Accepted solution]

Little typo, this may still not work, but give it a shot

=Sum({$<[BS Date]= {"$(=Date(Max([BS Date]), 'MM/DD/YYYY'))"}>} [Total Adjusted Fair Value])

[#5]

Sunny,

Thank you.  That one worked.

[sunny_talwar]

Cool, Stupid mistake on my end, but glad it got quickly resolved.

Best,

Sunny