Hard round vs. soft round

Hello,

In my reports when I select 0 decimal places it does a hard round, which means if I create reports off the same data at varying levels, the totals are off becasuse it's actually rounding the number at each level and not just a "visual rounding."

What I want is to have the numbers look rounded but the actual numbers to still carry their true amounts so the totals are the same no matter what level of detail is in the report. Is this possible in report writer?

Find more posts tagged with

Infor Lawson Financials Group - Discussion

Comments

amacknig

Ah! someone else that is annoyed by the RW rounding feature! I've been writing Report Writer reports for 22 years...and the only work around i could figure out was to insert consolidated detail in the row that prints but does not affect totals.

unknown

I'm not understanding, glad to hear there is a workaround but I am very new to Lawson so I need a little more detail. When I go to edit the row the current rows are pulled at the account detail. For the rows that are Type "D", if I change those to consolidated, it still shows the report rounded to 2 decimal places. Do I need to change it to 0 decimals and then select the consolidated instead of account? I'm also getting thrown off by your comment about rows that print but do not affect the totals, as all of these rows would foot down to the totals... Your help is much appreciated

amacknig

i am not exactly sure of what your report is...but for example, lets say you want a list of expense accounts to print by account totals, or a list of accounts by the subaccounts...when the report writer sums them it rounds incorrectly to the actual totals of either the all expense accounts or the subaccounts to the totol account..so you go to the row, where the total should appear, make the total line a does not print, insert a line with the summarized total you want, under the more button, options tab, there are various options, different formats, etc and one that says "Print LIne" Y or N, and Affect Total A, add, S, subtract and N, do not affect total. If i have lost you somewhere along the way, you can call me, (509)467-3627 it is a lot of tedious work, but it's all about making the visual report look correct. i also have an old presentation I gave at a Lawson CUE conference (that was before it was Infor), and it has some RW information that could be useful. the screen shots are all from when we were on LID, but the essential information is the same.

Copyright © 2025 Infor. All rights reserved.