New Column Creation

[Anonymous]

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

[Anonymous]

Thank you so much padmanabhan