Calculated columns with multiple IF's conditions

Question

Hello All ,&nbsp;I have a scenario as below . I need to have a calculated columns with below condition as shown in the below table(Calculated columns).&nbsp;I have used switch as below but not getting the answer:&nbsp;Column = SWITCH(CF_Savings_Ownership[Attribute],"One year ago", CF_Savings_Ownership[page2_WT] * 1 ,"Two years ago", CF_Savings_Ownership[page2_WT] * 2,"More than 5 years ago", CF_Savings_Ownership[page2_WT] * 5,"null")&nbsp;&nbsp;Attributepage2_wt&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; calculated columnsMore than 5 years ago0.023(if attribute = 'one year ago ' then page2_wt * 1 ,if attribute = 'Two years ago ' then page2_wt* 2 ,If attribute = 'More than 5 years ago' then page2_wt * 5)More than 5 years ago1.023More than 5 years ago2.023One year ago3.023One year ago4.023More than 5 years ago5.023More than 5 years ago6.023More than 5 years ago7.023Two years ago8.023&nbsp;Regards ,Ankit

anonymous · Accepted Answer

Hi ANKITBISANI,&nbsp;You can also try to use switch function.&nbsp;Calculate column:&nbsp;Reuslt = 
var multi=SWITCH([Attribute],"one year ago",1,"Two years ago",2,"2-5 years ago",3.5,"More than 5 years ago",5,0)
return
[page2_wt]*multi +if(multi=0,2000)&nbsp;Regards,Xiaoxin sheng

Forum Discussion

Related content

Multiple conditions Index

Conditional formatting using multiple calculation groups

Multiple Donut charts with conditions

Conditional Column with Multiple Conditions

Switch Calculation with Multiple conditions