Skip to Content
0
Former Member
Apr 17, 2014 at 11:15 AM

Help regarding Calculated Column

22 Views

Hi Frzz,

I need some help in solving below issue.

I have a table in which i have 3 fileds called Counter, Actual, Link.

I need to populate the data in to a calculated Column in which the condition is like,

If( Link != '0', Then pick the value of 'Actual' corresponding to the counter value ( which is eual to link ) )

Counter Actual Link Calculated Column 1 12.5 0 2 11.5 0 3 25.5 1 12.5 4 11.5 1 12.5 5 10.23 2 11.5 6 14.5 3 25.5

Could some one please help out me to do this.

Best Regards,

Krisna.