XpressDox Help Center

Use Google To Find Help Fast, e.g. xpressdox choosefromlist


Press Getting Started in the XpressDox toolbar for basic template development
Watch the tutorial videos
View command help from list of commands
Press F1 for help on a command in the Command Editor
Email support@xpressdox.com for assistance

Look up a fee in a tariff table


Look up a fee in a tariff table

The legislated tariff for a particular type of fee that can be charged is worded something like this:

“Where the capital amount is less than or equal to $3000, the fee is $56;
Where the capital amount is greater than $3000 but less than or equal to $5000, the fee is $187;
Where the capital amount is greater than $5000 the fee is $277.”

The fee could be calculated as in the following snippet, using a sequence of When commands:

The fee for capital amount $<<CapitalAmount>> is <<When(CapitalAmount <<When(CapitalAmount > 3000 and CapitalAmount <<When(CapitalAmount > 5000,$277)>>

OR, we could use the TableLookup command as follows:

The fee for capital amount $<<CapitalAmount>> is $<<TableLookup(CapitalAmount,'3001;56;0, 5001;187;0, 999999;277;0')>>

If the command looks a bit intimidating, you’re in good company! But using the Command Editor you can use a wizard to help construct the command and table. Open the Command Editor from the XpressDox toolbar, and right-click on the TableLookup entry and choose one of the wizards.

Note the following:

  • The “rows” in the table are separated by commas, and the items in each row are separated by a semi-colon.
  • The entire table is enclosed in quotes.
  • It would be possible for the table to be sourced from a data source, for example, in which case suppose the data element name in which the table is stored is called FeeTable, then the Fillpoint would be <<TableLookup(CapitalAmount,FeeTable)>>

Leave a Reply