Forum Discussion

KatkaS's avatar
KatkaS
Icon for Post Patron rankPost Patron
6 years ago
Solved

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!

 

 

 

Need Help

4 Replies

  • bheepatel's avatar
    bheepatel
    Icon for Resolver IV rankResolver IV
    6 years ago

    Hi KatkaS 

    Can you try using an IF statement:

    Amount2 = IF(ERP = "Scala", Amount * 1000, Amount)

    • KatkaS's avatar
      KatkaS
      Icon for Post Patron rankPost Patron
      6 years ago

      Thank you very much, Amit, as always!