Forum Discussion

adityavighne's avatar
adityavighne
Icon for Continued Contributor rankContinued Contributor
6 years ago

Add target column to calculated table

Hi,   I have calculated column and I want to add target for that and get difference value. How can I do this.   Name,Open,Close and total is calculated table and Target, Difeerence column I want ...
Need Help
adityavighne's avatar
adityavighne
Icon for Continued Contributor rankContinued Contributor
6 years ago

Anonymous  

I want to add target for each by hard coding.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

 

You can use SWITCH statement to list target as 50 for A , 100 for B , 150 for C etc. SWITCH ("ColumnA","A",50,"B",100,"C",150,0)

 

Regards

Rohit