COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: tosty on 18 Jan 2007 05:24:48 AM

Title: [RS8] Filtering /0 (Division by 0 values) measures
Post by: tosty on 18 Jan 2007 05:24:48 AM
Hi to all,

I have a crosstab with a PowerCube as DataSource.

I would like to filter lines where the measure value is /0 (Division by 0), this value came from the cube, I did not calculate this column on the report.

I am using the NOT NULL sentence but it didn't recognized that value as a null neither as a 0.

Is there any way to control the /0 values in RS8 with a cube as datasource,

ThankÃ,´sÃ,  ;D
Title: Re: [RS8] Filtering /0 (Division by 0 values) measures
Post by: MDXpressor on 18 Jan 2007 10:43:56 AM
try using the filter() function: 

filter([set_exp],currentMeasure = '/0')