I have a loop that builds a table for as many records as there are in the recordcount. Now I would like to:
1) Take the ExtPrice and make a subtotal
2) Multiply the subtotal by .07 to get tax.
3) Add the tax to subtotal to get total.
I assume I need to assign values to a variable during each pass of the loop? Would this be hard to do?
This is what the results presently look like:
SKU ProductName Brand Unit Price Qty ExtPrice
11072 100% Trophic $15.19 2 $30.38
11723 ALFALFA Trophic $10.07 2 $20.13
11912 APPLE Trophic $9.11 2 $18.23
and here is the code that does it:
<cfloop index="x" from="1" to="#SearchResult.recordCount#">
<cfif SearchResult.ResultField5[x] is not 0>