Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
3 replies Latest Post - ‏2013-01-02T10:06:07Z by SystemAdmin
SystemAdmin
SystemAdmin
15496 Posts
ACCEPTED ANSWER

Pinned topic Cognos 10 Report Studio Question

‏2012-12-26T15:33:15Z |
I have been faced with a reporting question. I am trying to write a report in Report Studio and insert a calculated field. The report consists of transactions listed by Company Codes as my rows and transaction types as columns. With my measure being the transaction amount. The tx types are (1,5,6,7). The calculated column I need is an equation with the TX types; 1-5+6-7.

Example:
Type 1 Type 5 Type 6 Type 7 Total
Company 1 5.00 6.00 7.00 8.00 -2.00
Company 2 10.00 5.00 8.00 9.00 4.00

Can someone recommend something that would deliver this result.

Thanks.
Updated on 2013-01-02T10:06:07Z at 2013-01-02T10:06:07Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    15496 Posts
    ACCEPTED ANSWER

    Re: Cognos 10 Report Studio Question

    ‏2012-12-27T18:04:59Z  in response to SystemAdmin
    Hi,

    Just drag a Query calculation from the Insertable pane--> tool box. And Add the Equation.

    Thanks.