Representing numbers in accounting format

Sometimes, you may want to represent the numbers on the report in accounting format.

If the numbers are negative, it will be represented within a bracket with the positive number, e.g. - 500 is represented as (500) in accounting format.

If the numbers are 0, it will be shown as "-".

Here is the sample code for you to transform your number to accounting format. The code of the indicator using is "M_AMOUNT" and the aggregation is SUM.

if(M_AMOUNT@SUM == 0) {
  return '-';
}else if(M_AMOUNT@SUM < 0) {
  return '(' + abs(M_AMOUNT@SUM) + ')';
}else {
  return M_AMOUNT@SUM;
}