KatkaSPost Patron6 years agoSolvedMultiply function.. Hello, I have a rather simple calculation to be made, but I'm not able to do it:( I have a table that contains two columns - ERP and Amount. I need tro create new column with Amount2 where Scala...Show Morebheepatel6 years agoHi KatkaS Can you try using an IF statement:Amount2 = IF(ERP = "Scala", Amount * 1000, Amount)amitchandak6 years agoKatkaS , Create a new column if([ERP] ="Scala",[Amount]*1000,[Amount])
bheepatel6 years agoHi KatkaS Can you try using an IF statement:Amount2 = IF(ERP = "Scala", Amount * 1000, Amount)amitchandak6 years agoKatkaS , Create a new column if([ERP] ="Scala",[Amount]*1000,[Amount])
bheepatel6 years agoHi KatkaS Can you try using an IF statement:Amount2 = IF(ERP = "Scala", Amount * 1000, Amount)
bheepatelResolver IV6 years agoHi KatkaS Can you try using an IF statement:Amount2 = IF(ERP = "Scala", Amount * 1000, Amount)
Related contentCustom Function to multiply ColumnsmultiplierDATESYTD functionfunction behaviorIF and Multiply
