Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have to calculate a cost, where I want to use the UNIT PRICE of the minus selection of TIME made by user.
TIME | UNIT PRICE | QUANTITY | CUSTOMER | ART | COST (QUANTITY * UNIT PRICE) |
202011 | 3 | 546 | A | A1 | 1638 |
202101 | 3,84 | 550 | A | A1 | 2112 |
202103 | 4 | 555 | A | A1 | 2220 |
202102 | 5 | 4 | X | A2 | 20 |
202103 | 6 | 12 | X | A2 | 72 |
1/ If user select TIME between 202011 and 202103, I want to use the UNIT_PRICE 3 for ART A1 and the UNIT_PRICE 5 for ART A2, because it's the price of the minus periode of selection
TIME | UNIT PRICE | QUANTITY | CUSTOMER | ART | PRICE FOR COMPUTE | COST |
202011 | 3 | 546 | A | A1 | 3 | 1638 |
202101 | 3,84 | 550 | A | A1 | 3 | 1650 |
202103 | 4 | 555 | A | A1 | 3 | 1665 |
202102 | 5 | 4 | X | A2 | 5 | 20 |
202103 | 6 | 12 | X | A2 | 5 | 60 |
2/ If user select TIME between 202102 and 202103, I want to use the PRICE_PER_ART 3 for ART A1 and the PRICE_PER_ART 5 for ART A2, because it's the price of the minus periode of selection
TIME | UNIT PRICE | QUANTITY | CUSTOMER | ART | PRICE FOR COMPUTE | COST |
202103 | 4 | 546 | A | A1 | 4 | 2184 |
202102 | 5 | 4 | X | A2 | 5 | 20 |
202103 | 6 | 12 | X | A2 | 5 | 60 |
Finaly, In my app, I don't want to display the ART LEVEL, I just want to diplay customer, cost
1/
CUSTOMER | COST |
A | 4953 |
X | 80 |
2/
CUSTOMER | COST |
A | 2184 |
X | 80 |
How can I have retrieve in my set analysis, the UNIT_PRICE of the minus selection for every ART?
Thanks for the help
Create a Master Calendar and then connect to your TIME field.
Selections made on the Master Calendar Year and Month fields would limit the output to only those within the selection