When users need to round financial values and they find that the "increase/decrease decimal" feature does not accurately suffice, they may use an alternate method for rounding. This "mathematical" rounding feature is not to be confused with "bankers" rounding. Mathematical rounding means that .5 values round up to the next largest whole value.
The "increase/decrease decimal" option will round each cell independently.. This means that the subtotal/total line could actually show a different value than the summation of the rounded rows above. This is because each cell is independently rounded, even the totals.
Enabling the "mathematical rounding" feature in Qvinci causes rounding to take place at the base report layer (ie: the Report tab), as opposed to simply rounding values in the Report Editor. This means that the account/subaccount values are rounded, and then the totals/subtotals are shown as as summation of the already rounded accounts/subaccounts from above. This means that the totals/subtotals always accurately show the summation from above.
Use Mathematical Rounding in Qvinci
- From Reports & Libraries > Libraries, open an existing template.
- Click the Report Options button in the top left of the Report Editor screen.
- Check the box titled "Rounding".
- Apply cell formatting to remove numbers after the decimal.