Need Help With A Currency Formula

Topic Labels: Formulas
1117 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi There

I have a column (Net Sales USD/CDN) that is populated with various mounts. In another column (Currency) I have indicated which of those amounts are USD currency and CDN currency.

In a new column (Total Net CDN Sales) I would like to come up with a formula where it converts the USD currency amounts to CDN currency using a currency rate of 1.3 and leaves the CDN currency amounts as they are.

Your help will be greatly appreciated.

Thanks so much.

2 Replies 2

Does this look right?


Here’s the formula in the final field:

IF(Currency="CDN", {Net Sales USD/CDN}, {Net Sales USD/CDN} * 1.3)

Hi Justin

Thanks so much for the help, it worked.

Much appreciated.