Calculating the value of a project fee
You can direct Infor Public Sector to calculate the value of a fee using a fee value formula. For example, you could write a formula that charges a base filing fee of $100.00 plus an extra $20.00 per $5000.00 worth of construction. You specify a fee value formula when you define a fee type. You first select Formula from the "Value" list in the Fee Type dialog box.
Fee value formulas use the
oProjectApp
object (an instance of the
Hansen.CDR.Project.iProjectApplication
class) to set
Value
to a decimal value. For more information about
this object and for sample code, click the
Information tab in the Formula
Editor.
Examples
This formula sets the value of a fee as a combination of a $10.00 base value and 5% of the declared value of the work.
Value = 10 + (oProjectApp.DeclaredValuation.round(oProjectApp.DeclaredValuation,2)*.05)
This formula assesses one $50.00 fee for any construction associated with an educational structure, and a $30.00 fee for all other occupancy types.
If (oProjectApp.OccupancyType.Code.ToUpper = "EDUCATIONAL") Then
Value = 50
Else
Value = 30
End If
This formula assesses a $10.00 per hour handling fee for extra work done by any employee.
value = 0
dim oApplicationEmployee as Hansen.CDR.Project.IApplicationEmployee
For Each oApplicationEmployee in oProjectApp.ApplicationEmployees
Value += oApplicationEmployee.TotalHours*10
Next oApplicationEmployee
This formula assesses a sliding-scale fee based on the building area.
If (oProjectApp.BuildingArea <= 1000) Then
Value = 100
Else If (oProjectApp.BuildingArea > 1000) And (oProjectApp.BuildingArea <= 5000) Then
Value = (oProjectApp.BuildingArea * .15)
Else If (oProjectApp.BuildingArea > 5000) And (oProjectApp.BuildingArea <= 10000) Then
Value = (oProjectApp.BuildingArea * .25)
Else
Value = (oProjectApp.BuildingArea * .50)
End If