Storing Data and Using that Data for Calculations

Overview

Create a table that can store number data. These numbers can then be used to calculate other values.

Ingredients

Guide

Create a table

• insert a Table Data macro

  • name it "purchaseTable"

• edit the parameters

  • set Initial Rows is 1

Inside the Table Data macro

• create a 4x2 table as below

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

• insert Text Data, Number Data and Evaluate Data macros into the table

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 Data macro

• type the following code:

${unitPrice} * ${quantity}

Adding hidden stored data

Underneath the Table Data macro you created above

• create a Hidden Data macro

In the Hidden Data macro

• add two Number Data macros

  • name them "discount" and "tax"

  • choose Allow Decimal Values for each

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

  $ #,##0.00

Type in the following codes in the respective Evaluate Data macros

• Net Total

  sumtable("purchaseTable","totalPrice")

• Discount Amount

  ${netTotal} * ${discount} / 100

• Tax Amount

  ${netTotal} * ${tax} / 100

• Grand Total

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

The Evaluate Data macros should look similiar to the following.

• Save/Update the page

• choose Edit Contents

  • input the values "10" and "0.5" respectively for the Discount percentage and Tax percentage fields

Result