Get the right unit price to calculate with selection

alex3049 — Thu, 05 Aug 2021 07:28:13 GMT

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

CUSTOMER	COST
A	4953
X	80

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

Re: Get the right unit price to calculate with selection

dwforest — Fri, 06 Aug 2021 23:32:03 GMT

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

topic Re: Get the right unit price to calculate with selection in App Development

Get the right unit price to calculate with selection

Re: Get the right unit price to calculate with selection