COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: noreply on 27 Aug 2009 02:48:13 AM

Title: how to put a formula field in cognos?
Post by: noreply on 27 Aug 2009 02:48:13 AM
hi,

need some help, used to design in crystal report & is fairly easy to add formula field into reports.

but cognos i have no idea how to do it. want to specified under certain condition of field A, field B only will display it's value.

something like this in crystal report. need to some to kick start.

(http://i625.photobucket.com/albums/tt335/alexlow2020/crystalrpt.jpg)

thanks

regards
Lex
Title: Re: how to put a formula field in cognos?
Post by: cschnu on 27 Aug 2009 09:11:56 AM
if you are in report studio hit F1 and it will bring up the help. I usually click on the PDF and then search from in there. Search for Create a Calculation and Using the Expression Editor
Title: Re: how to put a formula field in cognos?
Post by: noreply on 27 Aug 2009 09:37:26 PM
Quote from: cschnu on 27 Aug 2009 09:11:56 AM
if you are in report studio hit F1 and it will bring up the help. I usually click on the PDF and then search from in there. Search for Create a Calculation and Using the Expression Editor

thanks for the advice, anyhow i already figure several ways how it can be done last night, cheers.