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