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

issue in a crosstab

Started by philelmousse, 19 Dec 2011 09:10:28 AM

Previous topic - Next topic

philelmousse

Hello,

I have a crosstab built like this :

                                   TimeDimension
Dimension1 Measure  Cells

I would like to create an "average" measure under TimeDimension depending on the number of days of the period in "TimeDimension".
But If I add a query item under TimeDimension like that :

total(currentMeasure within set [TimeDimension])/
extract(day,_last_of_month([LOGICAL LAYER].[Fact].[HDATE]  ))

My entire crosstab returns blanks...

Do you have any idea to make that ?