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

Percentages off

Started by mbrassfi, 22 Feb 2010 03:29:13 PM

Previous topic - Next topic

mbrassfi

I have built a list and I have some data items in the query that take a simple percentage - YTD/Budget - and it works 90% of the time, but every once in a while it gives me a really goofy number that does not seem to have any rhyme or reason.  Any ideas on how to fix this?

MFGF

Hi,

My guess is that your calculation is being done at the detail level then aggregated by the report where there are multiple rows with the same descriptive information.

I'd also guess that the expression for the calculation uses items from the package rather than from the query (ie the expression looks like [namespace].[query subject].[YTD] / [namespace],[query subject].[Budget]).  If this is the case, make sure YTD and Budget are items in te query, and change the expression to [YTD] /[Budget] and this should alter the timing of the calculation to be after aggregation.

I've made a couple of big assumptions there - apologies if I'm barking up the wrong tree!

MF.
Meep!