on 12-06-2017 6:13 AM
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.
try this.
[Plant] Where ([Expected Delivery Date] = Min([Expected Delivery Date]) in ([Plant])
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.