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?
Hi,
You could try using a Tuple function
[2009]/Tuple([2009],[Member Months])
Does this give you what you need?
MF.
It worked perfect!! Thanks for your help! I never used that function before - just learning!!
;D