Page Comparison

...

For this example, add the following names for each macro

• Text Data: item

• Number Data: unitPrice

• Number Data: quantity

• Evaluate Data: totalPrice
  

In the Evaluate the Evaluate Data macro

• type the following code:

${unitPrice} * ${quantity}

...

• create a Hidden Data macro

In the Hidden Data macroData macro

• add two Number Data macros

  • name them "discount" and "tax"

  • choose Allow Decimal Values for each

...

• Net Total (excluding tax and discount)

• Discount Amount

• Tax Amount

• Grand Total (including tax and discount) 

Add four Evaluate Data macros for each of the values above and give them relevant names, as below


For each Evaluate Data macro

• enter the following in the Display Format properties

  Code Block
  $ #,##0.00

Type in the following codes in the respective Evaluate Data macrosData macros

• Net Total

  Code Block
  sumtable("purchaseTable","totalPrice")

• Discount Amount

  Code Block
  ${netTotal} * ${discount} / 100

• Tax Amount

  Code Block
  ${netTotal} * ${tax} / 100

• Grand Total

  Code Block
  ${netTotal} - ${discAmt} + ${taxAmt}

The Evaluate Data macros Data macros should look similiar to the following.

...