cancel
Showing results for 
Search instead for 
Did you mean: 

Need help on Min function in webi

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

amitrathi239
Active Contributor
0 Kudos

try this.

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

Former Member
0 Kudos

Hi Amit,

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

amitrathi239
Active Contributor
0 Kudos

Can your share some sample data and expected result