Problems with Formula
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 Date||Scheduled 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..