Use Google to find help fast. For example, search on "xpressdox choosefromlist".

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