if else if error

I think an else is missing and I do not think “* 45%” is going to work would be: “*0.45”. And a query about something being identical would be “==”:

if( column("CHANNEL") == "PLATINUM" ) { column("VAS_ADJ_QUOTA")*0.5   
}   
else if ( column("CHANNEL") == "TERRITORY" ) { column("VAS_ADJ_QUOTA")*0.45   
}   
else { 999.99
    }
3 Likes