Forum Discussion
KatkaS
6 years agoPost Patron
Multiply 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 Amounts should be multiplied by 1000, the rest stays the same..
Could you please help?
Thnak you!
Hi KatkaS
Can you try using an IF statement:
Amount2 = IF(ERP = "Scala", Amount * 1000, Amount)
4 Replies
- KatkaSPost Patron
Thank you!!
- amitchandakSuper User
- KatkaSPost Patron
Thank you very much, Amit, as always!