1 Overview

A Revenue Header is a complex question type which is used for allow the storage of margin on an amount to be easily recorded.

The fields are

This question type is not searchable by design.

2 Logic

The fields themselves are formatted as currency with , used to separate thousands.

Worked example:

Where a Price is given 1000, the system will multiply the value in the VAT Rate percentage to calculate the VAT
The system then will add the Price and the VAT to store the value in the Total
Whatever value is in the Cost field is then subtracted from the Price to give the Net Margin
Whatever value is in the Cost field is also subtracted from the Total to give the Gross Margin

The Currency fields are currently provided for reporting purposes, not calculation purposes.

All of the calculation fields are recalculated and reformatted on any attempted change.

The VAT Rate will always be stored with a % in it

* For developers

All fields, TDs, TRs and tables are uniquely named to allow total control styling.

The calculation function is fn_Revenue_Recalc_X where X is the Id of the question added.

The system has been built to support multiple Revenue Headers on the same form with no conflict.