COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => COGNOS Planning => Topic started by: lanalana on 14 Jul 2011 04:45:27 AM

Title: Dlist Calculation with exponential
Post by: lanalana on 14 Jul 2011 04:45:27 AM
Hi everyone

Does anyone have an idea on how to make calculation or something similar in order to make a exponent calculation? For example, I have an interest rate (5%) and number of periods (12). I want to calculate exponential value for 5^12, that is 3125. I know that there is a Dcube command for this (power), but I need something that would automaticaly calculate this number, without the need to manually enter "power" command.

Any ideas?
Title: Re: Dlist Calculation with exponential
Post by: John 27182 on 15 Jul 2011 06:04:59 AM
Hi Ianalana,

My understanding is that you have a D-List with three items. The user enters data for two of the items, and you want the third item to be a calculated item.

The calculation {item1}^{item2} seems to work for me.

Regards,
John
Title: Re: Dlist Calculation with exponential
Post by: lanalana on 15 Jul 2011 07:14:11 AM
It works!
Thanks a lot!
I thought I can only make +,-,* and / calculations, I couldn't find anything about exponentials in Help documentation..
Thanx again :)