7 Replies Latest reply on Apr 6, 2017 7:44 PM by pbedouk

    How to display a negative Summary field as positive?

    pbedouk

      HI

       

      I have banking transactions (debits) which get imported as negative numbers (as they should). When creating reports using Summary fields which Total or Average the transaction amount fields (which are all negative), the result of course is also negative.

       

      How can I display those Summary fields as positive numbers on a layout?

       

      I could create a separate calculation field and use the abs function on the summary field, then display the calc field in the SubSummary part ... but that seems a little excessive.

       

      Is there a better way?