COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Query Studio => Topic started by: daviddstewart on 26 Sep 2014 11:39:01 AM

Title: Report Calculation - Viewing the syntax of the calculation in the Expression box
Post by: daviddstewart on 26 Sep 2014 11:39:01 AM
Hi Everyone,

I created calculations in Query Studio but I am unable to view the calculation syntax in the expression box after creation.

When I right click on the column that has the calculation and choose the calculate icon, it thinks I want to create a new calculation with this column.

How do I view the calculation syntax that already exists in that calculated column?

Thanks!
Title: Re: Report Calculation - Viewing the syntax of the calculation in the Expression box
Post by: bdbits on 26 Sep 2014 02:50:46 PM
If it is already a calculation and you choose the calculate icon (or from the context menu), it will show you your existing expression in the dialog at the bottom.
Title: Re: Report Calculation - Viewing the syntax of the calculation in the Expression box
Post by: daviddstewart on 26 Sep 2014 06:23:38 PM
Thanks Everyone,

I sorted it out.

Turns out that when you rename the calculation under "New Item Name", the expression shows the new name, not the components of the query.

To see the components of the query, you have to select report definition...