| Description |
Axel
Remember :
you must sum after you round or results may loook weird
!pastedImage_d41257_0.png! At the report level can we place an override to apply rounding to the whole report.
The one thing that will come up on a Trial Balance
* The Total of the round may creae a difference on the rounding so there is one more stratagey that will have to be applied
* you will have to keep the amount of the rounding and allow the user to specify where to place it on the row format -
*Additional item:*
* We should add an additional Row type of Rounding
* For adding the amount that is rounded or the balance will not function properly
note below how the amount of the round of the subtotals needs to be added back to the amount to get the proper value.
| |Amount| | | |
|Asset Account 1|1.5|2| | |
|Asset Account 2|1.5|2| | |
|Asset Account 3|1.5|2| | |
|Asset Account 4|0.0007|0| | |
|Asset Account 5|-1.1|-1| | |
|Asset Account 6|1.5|2| | |
|Asset Account 7|0.22|0| | |
|Total|5.1207|7|Total Round|1.8793|
|Rounding| |-1.8793| | |
|Adjusted Total| |5.1207| | |
| | | | | |
|Liability 1|-5.82|-6| | |
|Liability 2|1.1|1| | |
|Liability 3|-0.0007|0| | |
|Liability 4|-0.4|0| | |
|Total|-5.1207|-5|Total Round|0.1207|
| | | | | |
|Rounding| |0.1207| | |
| | |-5.1207| | |
so - could we put a mask and show how we want to round
for example
###,RRR.RR would round to the thousands.
!pastedImage_d41257_1.png! if the column format is
###,###.RR
Round Cents
if the column format is
###,RRR.RR
then 1923.33
would round to 2 on the report
(see example below)
!pastedImage_d41257_2.png!
|