No Translation available yet
You have Slovak selected as language but this page has not been translated yet. Translate the page or view the content in the default space language below.
Display default
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;
}