Bookmark this page Print this page

Templates, Inserting A Formula

Durell may contain certain fields, such as the percentage of commission due to an introducer, but sometimes lacks the actual total. In such a situation you can get Word to calculate the total for you. In order to do so you’ll need to take the following four steps (which are explained in detail afterwards)…

1. Create a table, like that shown below, which may contain both data fields and text….

Your commission =

???

«PolComm_Rate5»

% of

«PolDets_CommissionPnd»

…that will look like this when populated by data from Durell…

Your commission =

???

60.00

% of

2469.00

2. Give names (or “bookmarks”) to the cells containing the data fields, so Word knows what you’re referring to, as shown below…

Your commission =

???

Percent

% of

TotalCommission

3. Enter the formula (e.g. = TotalCommission / 100 * Percent), like that below…

Your commission =

1481.40

60.00

% of

2469.00

4. Finally you may wish to make the table’s outline invisible, so the whole lot can appear as part of a sentence.

To do the above in Word, starting from an existing template in Durell….

  

Your commission =

  

% of

 

Your commission =

 

«PolComm_Rate5»

% of

«PolDets_CommissionPnd»

Your commission =

0.00

«PolComm_Rate5»

% of

«PolDets_CommissionPnd»

Your commission =

0.00

«PolComm_Rate5»

% of

«PolDets_CommissionPnd»