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