COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: lorenmario on 16 Sep 2013 09:29:10 AM

Title: Calculate percentage between time periods
Post by: lorenmario on 16 Sep 2013 09:29:10 AM
Hello!
I have a Crosstab report that accesses a relational model of the Framework, the lines display some indicators and columns months.

I need to create calculations that show the percentage growth between the months, it is possible to do this without using a cube?! I am using Cognos 10.1.1

Please help me, urgent!!
Thank you!
Title: Re: Calculate percentage between time periods - URGENT!!!
Post by: adik on 17 Sep 2013 06:11:55 AM
running-difference([measure] for [month])/[measure]
try something like this, i can't test right now so i can't be 100% sure of the syntax or result
Title: Re: Calculate percentage between time periods
Post by: lorenmario on 17 Sep 2013 01:31:18 PM
Hi friend, thanks for replying.
My report accesses a relational package, this calculation works for relational packages??

Thank you!
Title: Re: Calculate percentage between time periods
Post by: adik on 18 Sep 2013 03:38:30 AM
yes it is for relational