Max() in set expression uninfluenced by specific selection?

[Anonymous]

Hi, I want to achieve that the Max() value (latest version of a REPORT_TYPE) is not influenced by the user selecting a REPORT_TYPE_NAME (from a list box) but only by selecting a PROJECT_NAME. I can't get Max() value to be uninfluenced by the user selecting a REPORT_TYPE_NAME. Then, logically, the Max() value is the selected value.

Tried this: =Sum(${<REPORT_TYPE_NAME=, REPORT_TYPE_ID={$(=Max(REPORT_TYPE_ID))}>} EXPRESSION_VALUE_01)

The line: =Max(${<REPORT_TYPE_NAME=>} REPORT_TYPE_ID) does overrule how I want it to be, but in the table I can't use this syntax since I need the expression values to be displayed.

How can I get this to work?

[lironbaram · Accepted solution]

use something like this

for Report_TYPE_ID create a varaible with the formula

vMaxReportID=Max(${<REPORT_TYPE_NAME=>} REPORT_TYPE_ID)

then your expression will be

=Sum(${<REPORT_TYPE_NAME=, REPORT_TYPE_ID={$(#vMaxReportID)}>} EXPRESSION_VALUE_01)

[Anonymous]

Hi, thanks! Now I know where I went wrong, dollar sign expansion... Works sound. Regards, Sander.