Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to use max function in BusinessObjects Information Design Tool

I am trying to use the "max" function in BusinessObjects Information Design Tool where I want to optain max date for "Last Outage Start Date" by the Unit Name.

I tried creating it this way:

max(@Select(SALES_FORECAST\Data part\Outage\Last Outage Start Date))

 

In (@Select(SALES_FORECAST\Data part\Unit Details\Unit Name))

The concept is to create similar computation in design tool as per the syntax in webi report

=Max ([Last Outage Start Date]) In ([Unit Name])

I would really appreciate if someone can guide me with the right syntax.

Thank you.

Former Member
Not what you were looking for? View more on this topic or Ask a question