Skip to Content

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

Problems with Formula

Hi All,

I am having alot of trouble with a formula I am trying to do for a WebI report. What I am trying to do is find a Date from a field called [Scheduled PGI Date] against the line in a order which shipped last.

Example:

Order#SO Line #PGI DateScheduled PGI Date
12341001/05/201510/05/2015
12342002/05/201505/05/2015
12343003/05/201520/05/2015

In the above example I want to pull out the [Scheduled PGI Date] of 20/05/2015 as the PGI against that line is the MAX PGI Date.

I have tried to do this as follows but for some reason it results in a Multivalue error and im being driven crazy:

=Max([Scheduled PGI Date]) In([Order Number])

Where(Max([PGI date]) In([Order Number]) = [PGI date])

Can anyone please help.

NOTE: I am an end user and do not have access to any of the backend stuff including universe editing etc..

Thanks,

Fionn

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