Print Page - How can I find last member is not null? (source : TM1 / Cognos 10.2.1)

Title: How can I find last member is not null? (source : TM1 / Cognos 10.2.1)
Post by: ersin.gulbahar on 17 Nov 2014 07:04:21 AM

Hi experts,
I have a crosstab. And columns tab is time dimension. Please look attached image . How can I find a value which is not null?

thanks in advance

Title: Re: How can I find last member is not null? (source : TM1 / Cognos 10.2.1)
Post by: CognosAnalytics on 19 Nov 2014 03:17:37 PM

Hello Ersin.gulbahar,
Lets say the values in the columns i.e. the months as shown in your screenshot, is a SET in a data item [MONTH SET].
Then your calculation to get the last value which is not null divided by the first value should be ...
TUPLE (
ITEM( TAIL( FILTER( [MONTH SET], [Measure] IS NOT NULL)),0),
[Measure]
)
/
TUPLE (
ITEM ( HEAD ([MONTH SET]),0),
[Measure]
)

Let me know if it helped.

-Cognos810

Title: Re: How can I find last member is not null? (source : TM1 / Cognos 10.2.1)
Post by: ersin.gulbahar on 20 Nov 2014 07:31:35 AM

thanks it works

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: ersin.gulbahar on 17 Nov 2014 07:04:21 AM