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...




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