COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Topic started by: tosty on 18 Jan 2007 05:25:12 AM

Title: [RS8] Filtering /0 (Division by 0 values) measures
Post by: tosty on 18 Jan 2007 05:25:12 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: anilkumar on 15 Mar 2009 07:51:54 AM
sorry tosty

iam also facing same problem, if u find solution please let me know asap

Thanks and Regards
anil kumar