Convert Get Balance
This utility will convert a Get Balance function to a Load Budget function. Specify the cell reference of the Get Balance Formula you wish to convert, the cell where the new budget input value will be entered as well as the cell referencing the Budget Organisation. Alternatively, select the Budget Organisation from the list of values provide.
Parameter | Description |
---|---|
Get Balance Function | Reference a cell containing a valid Get Balance function. |
Input Value | Enter a numeric value. This is the budget amount that will be loaded. |
Budget Organization | Enter or select a budget organisation name. |
If the Get Balance formula contained “%” for any of the segment values, then the newly created Load Budget function will return Error (Segment). You are required to specify a specific segment value for Load Budget functions.