IBM Support

IV95499: SYSTEM FILTER APPLIED TO A REPORT WILL CAUSE REPORT TO FORMAT TOTALS DIFFERENTLY

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as documentation error.

Error description

  • When you add a system filter to a report that subtotal values,
    for instance work tasks material total, the subtotals don't add
    up.
    If you remove the system filters the values add just fine.
    You can reproduce by creating 3 work tasks and add a
    responsible person (i.e.: Abe Abstractor) to be easier to spot.
    Each of the 3 work tasks have one currency: US Dollars, AUS
    Dollars, Euro.
    Create a query report to list all work tasks, add columns for
    values like material or time costs.
    Add a system filter to see only work tasks that responsible
    person = Abe Abstractor (or the one you have chosen)
    The values will not add up correctly.
    Remove the system filter and it will calculate just fine.
    

Local fix

  • Remove the system filters.
    

Problem summary

  • Need to add a description about what is expected when summing
    non-base currency fields.
    

Problem conclusion

  •  If you sum a currency field, and it is not the base currency
    field that other fields convert into the base currency, then
    the summation of the column will just add the numbers up,
    without regard to the currency, and the currency UOM at the end
    of the report will be just the last UOM that happened to occur
    on the last record before the total row.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IV95499

  • Reported component name

    TRI APP PLTFM R

  • Reported component ID

    5725F26RE

  • Reported release

    350

  • Status

    CLOSED DOC

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-04-27

  • Closed date

    2017-05-01

  • Last modified date

    2017-05-01

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSHEB3","label":"IBM TRIRIGA Application Platform"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"350","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
30 March 2022