Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
In given two set of data. In First set I have Data, Product & Qty and in another set I have Date, Product & Price.
I want to calculate Date & Product wise Amount on the basis of Product Price.
Amount Formula :- Qty*Price
But problem is that in Price data set. I have only Product Price applicable Date.
Product P1 Price will be 100 from 01-01-2018 to 14-01-2018
125 from 15-01-2018 to 03-02-2018
120 from 04-02-2018 to 11-03-2018
169 from 12-03-2018 to 14-03-2018 and
161 from 15-03-2018 to till the next update date.
and this condition will be applied for all products.
Hello, Lalit1
Try to use IntervalMatch function for solving such issues:
Hi,
Have a look into this QVW