5 Replies Latest reply on Feb 9, 2017 1:55 PM by Shawn Wallwork

    Currency formatting

    Jeff Strauss

      I'm not sure if this should be a brain-teaser or not...

       

      What options are there for formatting of currency based on a country code?  In the attached example, we are working with US dollars, GB pounds, and EU Euros.  All of them have unique measure columns for the amount.  Right now our analysts are creating 3 separate worksheets and using dynamic visibility to determine which worksheet to show, but I do think there's a better mousetrap, not sure though...

       

      Here's a simplified example...

       

      Current state:

       

      Desired state:

       

      Attached is the workbook.  The problem is when we try to do a calc ("Calculation1") based on the currency code, then we get an error that says we cannot mix aggregate and non-aggregate.