COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: div_1234 on 31 Aug 2011 03:22:36 PM

Title: cellvalue()
Post by: div_1234 on 31 Aug 2011 03:22:36 PM
hi

how to use cellvalue() function in the expression,it gives me error.

Can we just use in else statement without argument

like

if ....

else

cellvalue()


i m getting error : A parsing error found near the position 0 in the expression

Any help
Title: Re: cellvalue()
Post by: blom0344 on 02 Sep 2011 04:34:34 PM
We had the same error message with reports on validating, though the report ran fine.  In case of a crosstab the error message was resolved by adding a dummy dataitem to the query with value 0  (zero) and assigning this as default measure for the crosstab  !!