The column of prices is also a calculation field with fixed values.
The following calculation syntax is used:
[price1] * [amount1]
A calculation for a multiple-choice question.
The following calculation syntax is used:
IF [Appliances] = 1 THEN 300 ENDIF +
IF [Appliances] = 2 THEN 350 ENDIF +
IF [Appliances] = 3 THEN 650 ENDIF +
IF [Appliances] = 4 THEN 1100 ENDIF +
IF [Appliances] = 5 THEN 600 ENDIF
This one is easy.
Totals per article are already calculated,
we just need to summarize.
The calculation syntax we used:
[tot1] + [tot2] + [tot3] + [tot4] + [tot5] + [tot6] + [tot7] + [tot8] + [tot9]
This calculation depends on the chosen method
for transportation. If the order for coffee
beans is more than $ 100, there will be
no transportation charges.
The calculation syntax we used:
IF [Transport] = 2 AND [totBeans] < 100 THEN 10 ENDIF +
IF [Transport] = 3 AND [totBeans] < 100 THEN 20 ENDIF
(since the first transportation option is free
it is not part of the calculation).
Calculated totals summarized:
[totApp] + [totBeans] + [totTrans]
A High tax rate applies to the appliance
and transportation only.
We used the following calculation:
( [totApp] + [totTrans] ) * 0.19
A low tax rate applies to the beans only.
We used the following calculation:
[totBeans] * 0.06
The invoice total is the sum
of the total + taxes:
We used the following calculation:
[totTotEx] + [totTaxHigh] + [totTaxLow]