When constructing your sales check-list in ancillaries, you can use in-built functions to apply certain costs when the job meets a certain criteria.

As a job is drawn and edited, the software keeps a running total of many job statistics. A few examples include; internal and external floor area, number of frames, hips, roof vents and whether the roof is glass, amongst others. There are also mathematical functions such as greater than, less than, equal or not equal to, which can then be used in IF and CASE clauses.

The large list of functions available can be found by right-clicking in the** price** field of the ancillary question. You can either then navigate through the different categories in the drop-down menu, or use **Search** and type in a search term.

The different functions each have their own output type. The value may be a string of text, a number, or a boolean (True or False) type answer.

**IsGlass** returns a boolean type value (1 if true, 0 if false)

**BarMaterial** returns a string of text – e.g Aluminium

**TotalFootingLength** returns numerical value – e.g 9000

Boolean Type functions can be incorporated as follows:

**If (IsGlass, 100, 20) **– If the conservatory has a glass roof, a charge of £100 will be applied, if the roof is not glass then a charge of £20 will be applied.

Text type functions can be used of compare against a string of text as follows

**If (BarMaterial = “Aluminium”, 50, 10) **– If the bar material is aluminium a charge of £50 will be applied, if the bar material is not aluminium a charge of £10 will be applied

Numerical type functions can be used as a multiplier when calculating a cost, or can be used with >,< <> or = operators as follows.

**If (TotalFootingLength >10000, 500,1000) **– If the total footing length of the job is less than 10,000mm (10metres), then a charge of £500 will be applied, otherwise the charge will be £1000