AnsweredAssumed Answered

How to display a negative Summary field as positive?

Question asked by pbedouk on Apr 6, 2017
Latest reply on Apr 6, 2017 by 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?

Outcomes