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.


Order#SO Line #PGI DateScheduled PGI Date

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..



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