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
Apps | Scaffolding |
|---|---|
Macros | Table Data |
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 each column in the header row Item; Unit Price; Quantity; Total Price
Item | Unit Price | Quantity | Total Price |
|---|---|---|---|
insert a Text Data, Number Data and Evaluate Data macro respectively into 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 Data macro
type the following code
${unitPrice} * ${quantity}The Evaluate Data macro should now look as below.
Adding hidden stored data
Underneath the Table Data macro you created above
create a Hidden Data macro
The Hidden Data macro is used when you want to enter data that you would rather not show to the reader of the page.
In the Hidden Data macro
add two Number Data macros
name them "discount" and "tax"
set Allow Decimal Values as “true” for both 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
$ #,##0.00
Type the following codes into the respective Evaluate Data macros
Net Total
sumtable("purchaseTable","totalPrice")
Discount Amount
Tax Amount
Grand Total
The Evaluate Data macros should look similar to the following.
Save the page
choose Edit Contents
input the value "10" for the Discount percentage field
input the value "0.5" for the Tax percentage field