max function

[upaliwije]

Hi

I have written following expression which does not return any value. Have I made any error in it.

SUM({<MONTH={'$(<=max(MONTH)'}>}ACTUAL)

[swuehl]

Is MONTH a field with numeric values?

What does

=Max(MONTH)

return in a text box?

[swuehl · Accepted solution]

In addition, it should look like

SUM({<MONTH={"<=$(=Max(MONTH))"}>}ACTUAL)

[upaliwije]

This is how I extract Month

Month(TRN_DATE) As MONTH,

[sibusiso90]

=SUM({<MONTH={"<=$(=max(MONTH))"}>}ACTUAL)

[sibusiso90]

Try the above and let's see how it goes.