| Using Lookup Tables in User Functions |  |
Using Lookup Tables in User Functions
The user defined functions also have the ability to use lookup tables. To define a table, see User Data - Tables to setup the table.
For example, if we had a lookup table that adjusted overheads based on the field size:
We could set up a function with a lookup table to use this relationship. The opcost is entered through the opcost data entry screen.
The equation is entered as above:
=@LookUpIndexAbove(Field_size,10000,1)
This lookup returns a value of 0.07 from the table above. We could then multiply this by our fixed opcost ($5,000 a month in this example) to get an overhead:
=5*@LookUpIndexAbove(Field_size,10000,1)
Refer to the Lookup Functions section in the function reference library for additional functions for lookup tables.
See also