Skip to Content
avatar image
Former Member

Need help on Min function in webi

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 06, 2017 at 07:13 AM

    try this.

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

    Add comment
    10|10000 characters needed characters exceeded