Calculating a Product Total


I want to Calculate a Total Amount of the product when the quantity changes.
So when Quantity changes to 2 and the product price is $10, it will calculate and automatically change the Total Amount to $20

i provided some screenshots to get a better understanding.

You should just be able to hit “more…” on that last field and do price * quantity and voila. The reason you can’t do that now is because the fields you are pulling from are set for Text (numbers only). They need to be set to integer or decimal to do math operations to them. If they need to be that way for another reason you could also do price’s value:converted to number * quantity’s value:converted to number.
Screenshot 2022-12-23 at 8.00.40 PM

Perfect! It works now.


1 Like