Distinguishing Funds

[ElGordo123]

I would like to compare our sales by currency type (U.S. and Canadian). I want both figures to appear on the report. I have two fields that I wish to derive this information from:
[TOTAL_CHARGES] (which is the actual amount) and [CURRENCY_CODE] (which is the type of currency - USD or CDN).

I have created two formulas (one for each currency). Here are the formulas that I have (they don't work the way I want):

Formula 1
if [CURRENCY_CODE] = "USD" then sum ([TOTAL_CHARGES])

Formula 2
if [CURRENCY_CODE] = "CDN" then sum ([TOTAL_CHARGES])


Any ideas why this is not working? Any help is appreciated.

Thanks in advance

 

[BFAGG]

You have not explained what it is you are getting and what you are trying to achieve. Based on the info so far, I would suggest minor amendments to the formulae:

Formula 1
if [CURRENCY_CODE] = "USD" then [TOTAL_CHARGES] else 0

Formula 2
if [CURRENCY_CODE] = "CDN" then [TOTAL_CHARGES] else 0

The formulae should then be placed on the detail line. You can then sum each formula at group or report level.

Hope this helps.

 

[ElGordo123]

Thanks for the suggestion. It works exactly the way I wanted.

Thank you very much.