Hi Everyone,
I have a requirement that i want to create a new output column using existing Equation column .
The output column is replaced with id names excluding _YY. Please find the attached sample data.
| ID | ID name | Equation | New Output Column |
| 124 | Days Sales | ([91_YY])/([225_YY]/365) | (Annual/ Annual days/365) |
| 91 | Annual | Null | Null |
| 225 | Annual days | Null | Null |
| 4826 | Sales | (([225_YY]-[225_YY-1])/[225_YY-1])*100 | (([Annual days]-Annual days-1])/[Annual days-1])*100 |
| 729 | Inventory | ([147_YY]/[236_YY])*100 | ([Inventory Carrying]/Total Product Revenue
])*100 |
| 147 | Inventory Carrying | Null | Null |
| 236 | Total Product Revenue | Null | Null |
For example :
([147_YY]/[236_YY])*100
ID 147= Inventory Carrying
ID 236= Total Product Revenue
New output column should be:(Inventory Carrying/Total Product Revenue)*100
Thanks in advance
