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

ConsolidatedAvg Function issues ignoring Zero Values

Started by anthony.mower, 09 May 2013 03:33:28 AM

Previous topic - Next topic

anthony.mower

Hi All

I have a problem with a rule in that I have 4 values against the weeks of a month one of which is zero, I want to use the ConsolidatedAvg function on these values in order to calculate the monthly average.

When I do this I am setting the flag value to 0 which I believe should mean that zero values will not be ignored however it seems that the calculation is still ignoring the zero's and is oly dividing the values by 3 and not 4.

Any help would be appreciated.

anthony.mower

Have now logged this with IBM who have replicated the issue and logged it as a defect with the development team.