How to Create a Custom Bill Formula

To create a custom bill formula, follow the procedure below:

How to Create a Custom Bill Formula
1.	Go to Agency Portal > Rates and Rules > Maintenance > Custom Bill Formulas > Bill Formula Maintenance. The Bill Formula Maintenance screen opens.
2.	Click . The Bill Formula Entry screen opens.
3.	In the Country field, change the country that is selected by default if you require the formula to apply to a country other than the default country.
4.	In the Name field, key in a descriptive name for the formula.
5.	In the Formula Type field, select Bill Rate Formula or Rate Matrix Formula depending on whether you want the formula that you are creating to be used to calculate bill results or to calculate gross profit margins respectively.
6.	In the Description field, key in a textual description of the purpose of the formula.
7.	In the Formula Builder section of the screen, click . A new, blank row is added to the *Formula* *Builder* section of the screen.
8.	In the Type field, select the type of component that is to be added to the formula. For more information about the different types of components that can be selected, see below.
9.	In the Component field, select the component that is to be added to the formula. For more information about the different components that can be selected, see below.
10.	If you selected Fixed Value at step 9, key in the fixed numerical value in the field that appears next to the Component field. Alternatively, if you selected a component that represents a variable value, such as pay rate, key in a numeric value for the variable component in the Test Value field so that you can test your formula.
11.	Repeat steps 8-10 until you have built out the formula according to your requirements.
12.	Test the formula by clicking . If the formula is valid, the Test Formula* pane displays the result of your formula. If your formula is invalid, an informative error* message is displayed and you will need to refer to the error message to determine why the formula is invalid and therefore how the formula needs to be fixed.
13.	When the formula has been tested successfully, click . The formula component is saved.

Note:
You cannot save a formula that is invalid. Once a formula has been used on a bill rate rule or in the rates matrix on a job order or job template, the formula is locked down and only the formula name and description can be edited.