Page Comparison

...

• create a 4x2 table as below

  • add to teach each column in the header row Item; Unit Price; Quantity; Total Price

• insert a Text Data, Number Data and Evaluate Data macros macro respectively into the each table cell under each header

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 set Allow Decimal Values as “true” for eachboth macros

...

Adding calculations

It's now time to make Scaffolding do some math and calculate the following

• 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 into 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 similar to the following.

• Save/Update the page

• choose Edit Contents

  • input the values value "10" and for the Discount percentage field

  • input the value "0.5" respectively for the Discount percentage and Tax percentage fieldsfield

Result

...