Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

IF Statement in Power Query

Hi Experts,   What's wrong with my statement? Why is throwing me an error?   Anyone, Please help  
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    4 years ago

    Its working Now

    if [CIR_WT_TYPE]= "SL" then ([ANF_WT]-[CIR_WT])/1000 else if[CIR_WT_TYPE]= "OL" then ([MANF_WT]+[CIR_WT])/1000
    else if[CIR_WT_TYPE]= "SP" then ([MANF_WT]+[CIR_WT])/1000
    else [MANF_WT]/1000)

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Its working Now

if [CIR_WT_TYPE]= "SL" then ([ANF_WT]-[CIR_WT])/1000 else if[CIR_WT_TYPE]= "OL" then ([MANF_WT]+[CIR_WT])/1000
else if[CIR_WT_TYPE]= "SP" then ([MANF_WT]+[CIR_WT])/1000
else [MANF_WT]/1000)