on 11-23-2022 1:06 PM
I have a vendors who has ordered multiple times , i want to find the first order date for both the vendors in WEBI .I am using the formula =Min ([V_Date] ForEach ([Order Date])) In([Planning Group]) but the results are not consistent for all the vendors .
Note : i created a dimension V_date : =ToDate([Order Date];"mm/dd/yy")
Planning group : Customer name
Eg:
Vendor 1 : ABC
Order date (mm/dd/yy): 1/10/19
3/07/20
2/10/22
Op Booking Qtr : 19Q4
20Q1
22Q1
Vendor 2 : XYZ
Order date (mm/dd/yy): 1/10/18
3/07/19
2/10/21
Op Booking Qtr : 18Q4
19Q1
21Q1
User | Count |
---|---|
86 | |
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.