How can I add lines to display converted currency after each group totals and lines only display if, say, non Canadian currency RRS feed

  • Question

  • Hi.  I am trying to add lines right after each group subtotal to show the converted currency of the group subtotal.  Also, these lines will only show if group subtotal is not in Canadian currency.

    For example:


    Glasses Vancouver $150.00

    Cover Vancouver $100.00

    Cover Calgary $80.00

    Napkins Calgary $200.00

    Subtotal $530.00


    Glasses Chicago $100.00

    Glasses New Jersy $50.00

    Glasses New York $100.00

    Cover L.A. $120.00

    Cover San Diego $100.00

    Subtotal $470.00

    Subtotal in CDN$ $517.00



    There can other groupings here like mexico, etc.


    How do I add this line and how do I only show it when required?


    Please advise.




    Tuesday, August 3, 2010 9:11 PM

All replies