LINEAR_MIN_MAX_RANGE_PARAM Formula
The LINEAR MIN MAX RANGE PARAM formula is a range formula. Range formulas let you set up unique parameters depending on the range in which the user input or the job values belong. For example, you can set up a minimum fee for job values less than $5000 that is different than the minimum fee for job values greater than $5000.
The LINEAR_MIN_MAX_RANGE_PARAM formula is a unique formula. This formula enables you to calculate fees based on user input as well as standard job values. This formula calculates fees based on job values or the value from a specific information field on an application. With a fee indicator, you determine what value you want to use when you set up the fee item. You can use a unique fee indicator for each specific information value or job value that you set up.
For example, if you set up a specific information field for an application to collect the total value of employee salaries, you can configure fees based on the value that a user enters. When you add a field to a specific information group, you assign a fee indicator to it. When you set up a fee item based on the specific information value, you must use the same fee indicator as an input parameter.
Formula Equation
$FI10100$ * a / B
Input Parameter Format
$Fixxxxx$,a1,B1,m1,M1,R1,a2,B2,m2,M2,R2,...an,Bn,mn,Mn,Rn
Example
$FI10100$,0.15,1000,30,150,200000,0.15,1000,30,150,1000000,0.15,1000,30,150,999999999.
Gross Receipt (in Additional Information, $FI10100$) is $210,000. The user enters 1 unit for the Business License Fee. Civic Platform calculates the fee as $210,000 * 0.15 / 1000 = $31.50
Input Parameter Definitions
| Fi | The fee indicator is a five-digit number between 10100 and 10599. Civic Platform uses the indicator to identify a job value, or a specific information value from an application. |
| a | The fee factor used to multiply the job value or the specific information value. For example, if you want to assess a fee based on 15% of an annual salary value, enter .15. |
| B | The modular base of the job value or the specific information value. The modular base determines how Civic Platform rounds off a job value, such as to the nearest tenth or hundredth. |
| m | The minimum fee that you want to assess for any value that falls in a specific range. |
| M | The maximum fee that you want to assess for any value that falls in a specific range. |
| R | The maximum value within a range of values. For example, if you want to set up input parameters for values that are less than $4000, enter 4000. |
Conditions
There is no limit to the number of ranges you can set up for this fee formula, but the total number of characters that you can use to enter input parameters is 500.
A fee indicator must be a five-digit number between 10100 and 10599.