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

Minimum across multiple insertable objects

Started by nestea, 27 Jul 2010 03:13:17 PM

Previous topic - Next topic

nestea

Greetings All,

Just trying to create a minimum value greater than zero across three calculated numerics [a], [d], and [c].

I used
minimum (currentMeasure within set [a], [d], [c])

The report validated - but I have empties on the Query Calculation I inserted.
Obviously I did something wrong - just trying to get the syntax down.

I appreciate all the views and replies in advance.

Cheers

MFGF

How about using a filter() function within the espression to exclude the members with zero measure values?

MF.
Meep!