Print Page - How to get a specific cell value in a list table?

Title: How to get a specific cell value in a list table?
Post by: duyluandethuong on 07 Oct 2014 04:47:29 AM

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)?

(http://www.cognoise.com/index.php?action=dlattach;topic=26103.0;attach=2989)

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.

Title: Re: How to get a specific cell value in a list table?
Post by: CognosAnalytics on 24 Oct 2014 03:12:50 PM

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

Title: Re: How to get a specific cell value in a list table?
Post by: duyluandethuong on 24 Oct 2014 05:39:15 PM

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

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: duyluandethuong on 07 Oct 2014 04:47:29 AM