COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => COGNOS Planning => Topic started by: LeeNash on 03 Apr 2013 10:10:14 AM

Title: Planning Analyst - Calculation
Post by: LeeNash on 03 Apr 2013 10:10:14 AM
HI,

I'm just starting to work with Planning - Analyst Version 8.4.1 and i've been told that in the calculation field of a Dlist I can type in formulas that dont exist in the BIF section, such as MID and LEFT.
I'm not sure I see this to be true and it doesnt work at all, can someone point me in the direction of any formulas that I can use in this calculation box and where I can get some tutorials on these?

Thanks

Title: Re: Planning Analyst - Calculation
Post by: ykud on 03 Apr 2013 07:30:58 PM
This would be a good place to start
http://publib.boulder.ibm.com/infocenter/c8fpm/v8r4m0/topic/com.ibm.swg.im.cognos.cp_a.8.4.0.doc/cp_a_id3606WP0101.html#WP0101

There's not so much, certainly no LEFT or RIGHT or any string manipulations as such

Cheers )
Title: Re: Planning Analyst - Calculation
Post by: LeeNash on 04 Apr 2013 03:49:26 AM
ok thanks, just looks like the standard add and other mathematical formulas.. thought so!

Thanks for your help