Anantha Krishna
Member
Hello All,
Can any one help on getting formula for the below requirement.
I have huge data list of products and price, i need formula to get Delta Price where i can apply in one shot for all the rows.
Each config product there will be Delta(N/Y) and i need the difference of the delta product price.
E.g:- 287 - 138 = 149
138 - 138 = 0.00
200 - 138 = 62
200 - 138 = 62
111 - 39 = 72
It will be really great if someone help on this.
Can any one help on getting formula for the below requirement.
I have huge data list of products and price, i need formula to get Delta Price where i can apply in one shot for all the rows.
Each config product there will be Delta(N/Y) and i need the difference of the delta product price.
E.g:- 287 - 138 = 149
138 - 138 = 0.00
200 - 138 = 62
200 - 138 = 62
111 - 39 = 72
It will be really great if someone help on this.
Config Price | Product Description | Product Price | Delta | Delta Price |
380 | HP IDS UMA i3-1115G4 nWWAN TBT640G8BNBPC | 138.00 | N | |
380 | Standard Packaging | 1.00 | N | |
380 | OS Localization | 0.00 | N | |
380 | FreeDOS | 0.00 | N | |
380 | Integrated HD 720p DM Webcam | 2.00 | N | |
380 | 14 FHD AG LED UWVA 250 fHDC NWBZ bent | 37.00 | N | |
380 | 16GB (1x16GB) DDR4 3200 | 39.00 | N | |
380 | 256GB PCIe NVMe Value SSD | 19.00 | N | |
380 | HP IDS DSC i5-1135G7 nWWAN TBT640G8BNBPC | 287.00 | Y | 149.00 |
380 | HP IDS UMA i3-1115G4 fWWAN TBT640G8BNBPC | 138.00 | Y | 0.00 |
380 | HP IDS UMA i5-1135G7 fWWAN TBT640G8BNBPC | 200.00 | Y | 62.00 |
380 | HP IDS UMA i5-1135G7 nWWAN TBT640G8BNBPC | 200.00 | Y | 62.00 |
380 | 32GB (2x16GB) DDR4 3200 | 111.00 | Y | -27.00 |