If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Anybody familiar with custom calculations in Report Studio Express?

Started by que5921, 01 Apr 2010 08:04:22 AM

Previous topic - Next topic

que5921

I've just started using Report Studio Express Authoring - I'm not very technical.  I've added a custom calculation column to my report but need some help with it.  Here's the scenario:

                 Total 2009            PMPM (This is my custom calc)
Revenue           $100,000        $20.00
Expense             $80,000         $16.00
Margin              $20,000           $4.00

Member Months   5,000   

In the Expression Definition the calculation says [2009]/5000.  That 5,000 could change monthly and I don't want to have to update it each month - I will forget!!  Can I make the denominator of that calc equal to the 2009 Member Months cell?  If so, how?

MFGF

Hi,

You could try using a Tuple function

[2009]/Tuple([2009],[Member Months])

Does this give you what you need?

MF.
Meep!

que5921

It worked perfect!!  Thanks for your help!  I never used that function before - just learning!!
;D