Price Variation

Question

Hi All,

I have a product and store ID level file for which we are trying to identify the change in price in same month for same product and store id:

We are trying to identify the latest variance in cost price in same month for same product and store ID..

Attached the raw file

Raw File -

GRN NumberGRN Generated DateProduct IDStoreIDPO NumberPO TypeCost Price12345626-09-2017 00:00AB-F00021232602688 110.122656123456701-09-2017 17:12AB-F00021232601736 107.98435218904520-09-2017 17:11AB-F00021232789345 9428654101-10-2017 17:11AS-F00021462601734 7528685610-10-2017 17:11AS-F00021462789344 20028685615-10-2017 17:11AS-F00021462789344 9128685620-10-2017 17:11AS-F00021462789344 20028685612-12-2017 16:11FM-F00021462789340 500

LatestOldPriceGRN NumberGRN Generated DateProduct IDStoreIDPO NumberPO TypeCost PriceGRN NumberGRN Generated DateProduct IDStoreIDPO NumberPO TypeCost Price12345626-09-2017 00:00AB-F00021232602688 110.12265618904520-09-2017 17:11AB-F00021232789345 9428685620-10-2017 17:11AS-F00021462789344 20028685615-10-2017 17:11AS-F00021462789344 91

Work.xlsx

danrh · Accepted Answer

Try something like this:

The Multi-Row Formula tool adds an incremental counter when the price changes.  The Unique tool then grabs the first of each of those increments --- the first 1 will be the latest price, and the first 2 will be the latest price where the price was different.  The Filters then grab the 1's and the 2's and Join them so you end up with a side-by-side comparison.

Hopefully this gets you closer.  Reach out if you need some more help!

ponraj · Accepted Answer

Attaching a sample workflow for your case. Hope this is helpful.

WorkflowResults

Scheruku · Accepted Answer

Thank you very much for your help.