Hello Everyone! New user to Cognos and I have been exploring Report Studio over the last few days.
Cognos Version: 10.2.1
Finance Software: ONESolution Finance v15.1
Package: Procurement
Scenario: I have an Encumbered Purchase Order totaling $50,000. The PO is broken down as follows:
GL Key 11111 - $25,000
GL Key 22222 - $15,000
GL Key 33333 - $10,000
What I need for this particular Purchase Order Encumbrance Report to provide is the following items: PO Number, Requestor, Vendor Name, Vendor ID, GL Key, GL Object, JL Key, Encumbrance Amount per GL Key, Year to Date Expenses per GL Key, Current Balance per GL Key, and finally a simple % Remaining (Balance per GL Key/Encumbrance Amount per GL Key.
I am aware that this info would have to come from Procurement, Encumbrances, Accounts Payable.
When I run into a problem is the Encumbrance Amount per GL Key, YTD Expenses per GL Key, Current Balance per GL Key. Instead of showing individual amounts, the current output is totaling the amounts. (see attached sample picture) I'd also like to add totals.
Is this a possibility? Any and all information is much appreciated.
Thank you,
LuisN87
Not exactly sure you can try this calculation total([PO Balance ] for [GL KEYS] )