1 Reply Latest reply on Mar 25, 2015 11:04 AM by Michel Caissie

    Help Totaling Multiple Currencies

    Ron Chipman

      Thanks to everyone who has posted a bunch of stuff on labeling and formatting when using multiple currencies, very helpful.

       

      Now, step 2 -- provide totals !

       

      We all know the story..."but I built it in excel to look like this, why can't your fancy expensive tool do the same thing?!"

       

      See the attached, which I embellished upon from one of the previous posts around formatting.  Look at sheet 2

       

      The detailed section looks great, but that darn GRAND TOTAL is a mess.  I need to get a single line item in the grand total, and I would have access to the proper currency conversion rates at the row level (we have several currency conversions as measures for each transaction).

       

      Thanks a million...

       

      Ron

       

      PS.  Ben Neville -- this is a slam dunk for you !