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

[ersin.gulbahar]

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

[cognos810]

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

[ersin.gulbahar]

thanks it works