Please help me to calculate total bill amount by multiplying product (QuantityRateTax) and then adding those amount for each product to get total bill value in LO Base Query.
For the total you will need to use “sum” on the column with your tax calculation:
Thanks for your suggestions.
W3Schools.com is a good resource for learning but couldn’t solve my problem. Please help me to figure out the sum of “Product” column in “Query1” to get the total value.
t107698.odb (13.0 KB)
The simpliest way would be a second query: SELECT (SUM) Product FROM Query1…
t107698 - First proposal.odb (14.3 KB)
Look this example:
You get my point. Now, I just want to get the sum of “Product” column that’s it. What will be the query for that.
t107698.odb (13.0 KB)