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
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi KatkaS 

    Can you try using an IF statement:

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

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    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!