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...
Need Help
  • bheepatel's avatar
    bheepatel
    6 years ago

    Hi KatkaS 

    Can you try using an IF statement:

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

  • amitchandak's avatar
    amitchandak
    6 years ago

    KatkaS ,

    Create a new column

    if([ERP] ="Scala",[Amount]*1000,[Amount])

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

KatkaS ,

Create a new column

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!