Skip to Content
0

Need help on Min function in webi

Dec 06, 2017 at 06:13 AM

33

avatar image
Former Member

We have plant ,material, product name, department, expected delivery date and category in webi report. I want to create a variable that will bring each Plant where the Expected Delivery Dates is minimum. Expected delivery date is in available objects and we are not using in report. I have tried the variable "[Plant] Where ([Expected Delivery Date] = Min([Expected Delivery Date]))" , but I am getting #multivalue error. Please help me on this.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

AMIT KUMAR
Dec 06, 2017 at 07:13 AM
0

try this.

[Plant] Where ([Expected Delivery Date] = Min([Expected Delivery Date]) in ([Plant])

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Amit,

thanks for your reply, its not working. Getting multivalue error.

0

Can your share some sample data and expected result

0