If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

[RS8] Filtering /0 (Division by 0 values) measures

Started by tosty, 18 Jan 2007 05:24:48 AM

Previous topic - Next topic

tosty

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

MDXpressor

try using the filter() function: 

filter([set_exp],currentMeasure = '/0')
No, a proof is a proof. What kind of a proof? It's a proof. A proof is a proof, and when you have a good proof, it's because it's proven.

-Jean Chretien