Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Start Date | End Date | Product | %Discount |
09-01-19 | 12-01-19 | A | 20 |
08-01-19 | 11-01-19 | B | 10 |
06-01-19 | 10-01-19 | C | 30 |
05-01-19 | 09-01-19 | D | 10 |
06-01-19 | 08-01-19 | E | 20 |
05-01-19 | 07-01-19 | F | 30 |
04-01-19 | 06-01-19 | G | 50 |
02-01-19 | 06-01-19 | H | 40 |
Date | Product | Cost |
11-01-19 | A | 1000 |
10-01-19 | B | 2000 |
09-01-19 | C | 3000 |
08-01-19 | D | 3000 |
07-01-19 | E | 4000 |
06-01-19 | F | 5000 |
05-01-19 | G | 1000 |
04-01-19 | H | 2000 |
i want after discount price
Hi there,
Maybe what you want is something like this:
=Sum(Cost) * (1-Sum(%Discount)/100)
Have this example attached
Best Regards,
MB
Thank you...
If this helped you mark as answered so the thread is closed. Have a nice day.
Hi,
as per my assumption based on the dates, I think the discount is going to change.
so you have to use the Interval match concept to check the Discount for the period.
sample Script:
Discount:
LOAD * INLINE [
Start Date, End Date, Product, %Discount
09-01-19, 12-01-19, A, 20
08-01-19, 11-01-19, B, 10
06-01-19, 10-01-19, C, 30
05-01-19, 09-01-19, D, 10
06-01-19, 08-01-19, E, 20
05-01-19, 07-01-19, F, 30
04-01-19, 06-01-19, G, 50
02-01-19, 06-01-19, H, 40
];
Costs:
LOAD * INLINE [
Date, Product, Cost
11-01-19, A, 1000
10-01-19, B, 2000
09-01-19, C, 3000
08-01-19, D, 3000
07-01-19, E, 4000
06-01-19, F, 5000
05-01-19, G, 1000
04-01-19, H, 2000
];
Inner Join
IntervalMatch ( Date, Product )
LOAD [Start Date], [End Date], Product
Resident Discount;
Thanks,
Mohammed Mukram
tq this more usefull for me
How to get after discount values using interval match