Expression Help

[#1]

Hi everyone, s

I want to show values for selected month maximum date. I am using using this expression

Sum({<TransactionDate={"$(=Max(TransactionDate))"}>} Sales )

Can someone help me on expression

Thank You

[sunny_talwar]

Add date formatting to make it work:

Sum({<TransactionDate={"$(=Date(Max(TransactionDate), 'YourTransactionDateFormatHere'))"}>} Sales)

UPDATE: Max converts TransactionDate into a number and set analysis comparison only works when the formats are same on both side of the equation. So in order to get it to work, you will need to add Date().

Also, make sure that TransactionDate is not a TimeStampField, because if it is, then you might need a more complex expression to get it to work, or you might need to create a only datefield using Date(Floor()) function in the script to perform set analysis.

[trdandamudi]

What is your date format ?

[swuehl]

As Sunny said, there might be formatting issues, see also

Dates in Set Analysis

But maybe there are some other issues, but it's hard to tell missing any description of what you get and what you expect to get instead from your expression (that would be a basic 'issue reporting').