Let's create a table that can store number data. These numbers can then be used to calculate other values.
- Insert a Table Data macro and name it "purchaseTable".
Edit the parameters of the macro so its Initial Rows is 1.
Inside the Table Data macro, create a table like this:
Item Unit Price Quantity Total Price
In the Eval Data macro, type the following code:
The Eval Data macro should now look like this:
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, create 2 Number Data macros and name them "discount" and "tax".
With each Number Data macro, click Allow Decimal Values.
It should look something like this:
- It's now time to make Scaffolding do some math.
- Net Total (excluding tax and discount)
- Discount Amount
- Tax Amount
- Grand Total (including tax and discount)
Create four Eval Data macros for each of the values above and give them relevant names, like in the following image:
For each of these Eval Data macros, enter the following in the Display Format properties:
Type in the following codes in the respective Eval Data macros:
Your Eval Data macros should look something like this:
Now save the page, and click Edit Contents.
Fill in the numbers and check out the results!
|Item||Unit Price||Quantity||Total Price|
Xbox One X
Net Total (excluding tax and discount) :$ 5,087.98
Discount Amount :$ 508.80
Tax Amount :$ 25.44
Grand Total (including tax and discount) :$ 4,604.62