I have to multiply 20-30 categories by a particular rate to generate a new set of 20-30 categories. That rate will vary over time so I want to store it in one category and then refer to that category in my Advanced Calculation in the new categories. So I only have to change one value to change alll of ther calculated categories.
So I have tried -
var res = 79.637
And when I test the calculation at Value and Sum Value level it tests ok and displays the value fine in the test box but if I try to get that value into another Categories Calulation with
var B=getCell("Network Allocation Rate").Value;
it returns a null value. Or if I display that Network Allocation Rate category in a scorecard it shows a null value on all items and at Sum Value level.
Any ideas on why it wont show the value in the category ?
Or is there any other way to store a global variable that I can use in my calculations across multiple categories ?
You can place your “Network Allocation Rate” vale in the function include file. Before version 8 the function include file is a text file located inside the ProSight install directory. Search your version's documentation on "include file" for the specifics. In version 8, they have moved it into the database.
The only bad thing about using an include file is that you need to stop and restart the function engine to get your new functions / variables complied and available to your category functions.
If your “Network Allocation Rate” is a number, I would consider using a value list. For example: