Multiply function..

[KatkaS]

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!

 

[bheepatel · Accepted solution]

Hi @KatkaS 

Can you try using an IF statement:

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

[amitchandak · Accepted solution]

@KatkaS ,

Create a new column

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

[KatkaS]

Thank you very much, Amit, as always!

[bheepatel · Accepted solution]

Hi @KatkaS 

Can you try using an IF statement:

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

[KatkaS]

Thank you!!