var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Display number as a positive in a report
What I need to do is display all the numbers on the report as positive but if they belong to a certain grouping they must be subtracted from the grand total.
My report is pretty simple. The underlying queries are pretty complex. So I would rather alter the report (if possible) than mess around with my queries.
Any help would be appreciated.
create a box that calculates the absolute value. The control source should be something like:
Or you could change your format property ... 0.0;0.0;0.0
but if you show all positive numbers, then any totals at the bottom cannot be verified using the paper report and a calculator...