Forum Discussion

Matas's avatar
Matas
Advocate II
4 years ago
Solved

Amount Calculations in Custom Column

Hello,   Anyone could help me out with Custom Column calculation? Currently, I have a calculation as [Gross_Amount] * [Currency Rate to USD] to get the total amount in USD.     [Currency ...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Matas's avatar
    Matas
    4 years ago

    Hi,

     

    So I was able to achieve wanted result by googling and also looking at amitchandak  example. 

    The following solved my issue:

     

    Regards,

    Matas

     

amitchandak's avatar
amitchandak
Super User
4 years ago

Matas ,

a new column in power query

 

if [currency] <> "CLP" then [Gross_amount]*[Currency Rate to USD] else [Gross_amount]*[Currency Rate to USD] /100

  • Matas's avatar
    Matas
    Advocate II
    4 years ago

    Hi amitchandak 

     

    Thanks for your input.

    Could I ask you to be more detailed? Since I do not have this [currency] field and I am merging fields, so after I have merged, I do not think so I can apply <> "CLP", since it was already merged on that before.