Multiplication with a constant value returning incorrect numbers
I am multipling some columns in the table with *1000 as there is a need to convert 1000s to Millions on our business end.
For eg. 222,000 is multiplied by 1000. I expect a result of 222,000,000. But I don't get the expected result. I see an increased number.
Has someone seen this issue before? I am using the Calculator tool for the multiplication in the Magic ETL.
Abhishek Shah
0
Comments

Are you summarizing the number first and then multiplying by 1000?
Can you show a screenshot of how you have the calculator tool setup?
Sincerely,
ValiantSpur
0