Multiplication with a constant value returning incorrect numbers

user00629
user00629
in Archive

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

Comments

  • Valiant
    Valiant Coach

    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

  • user00629
    user00629

    Thanks for the reply.

     

    You can check the workflow and the configuration of the calculator tool in the attached workflow.

    The other tools are not doing anything to the fields that are in the calculator tool.

    QQ.jpg 43.4K

Categories