Wanting to sum a number field with the condition the Date field is the max.

[Woody]

Hi All,

Wanting to sum a number field with the condition the Date field is the max.

Below is my attempt but it's throwing nothing back. 

Sum({<DATA_DATE=Max(<DATA_DATE>)>}TOTAL [VOL_P])

Can someone help with this please.

[arulsettu · Accepted solution]

Try like this

Sum({<DATA_DATE={'$(=Max(DATA_DATE))'}>}TOTAL [VOL_P])

[Woody]

Hi,

Would it be possible to explain the syntax in the solution so that I get a better understanding.