Using built-in functions

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

Was this article helpful?

Related Articles