If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to get a specific cell value in a list table?

Started by duyluandethuong, 07 Oct 2014 04:47:29 AM

Previous topic - Next topic

duyluandethuong

Hi all,

I have a report consist of 3 columns as you can see in the attachment. For the line that has the "accn" = 110, it is the sum of record 111 + 112. How can I write report expression to retrieve that sum (for the record that has accn = 110)?



Please note that the data in these columns are exported from Infor ERP LN and I use the Cognos Report Studio to edit the report.

Thank you.

cognos810

CASE [Accn]
WHEN 110 THEN [SoCuoiNam]
ELSE 0
END

duyluandethuong

Thanks for your reply, I will check it when I come to the company on Monday and get back here to update.