This content has been marked as final. Show 1 reply
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:
Name => Weight
FY2010 => 2.34
FY2011 => 3.12
FY2012 => 4.21
Now to use the value list, just get from the list the rate you want by the name and multiple it to your category.
var rate = getValueList("FY List", "FY2011");
var value = getCell("Base Value").Value;
if (value != null) return value*rate;
*** remember to watch your nulls if you have set the system to treat nulls as 0.
Using a value list provide the ability to update the list and retest you function without bouncing the function engine.
On a side note, you can use a list pointing to another list that provide you the ability to return a lookup text value.