I have a form in which users select quantities of various items.
The form calculates sub-totals (using quantity * price) then sums the sub-totals to give a grand total.
This works great on the front end, but I'm finding that the grand total values reported in my Notification emails are zero.
I'm guessing this is because the formula I'm using for the grand total field is the sum of sub-totals, which are themselves calculated using a formula.
This looks like a bug to me. If I base a formula field's value on the value of another formula field it works in the front-end but not in emails. Can anyone help with this?
A Simplified Example of what I'm doing:
Field 1 Qty: Number
Field 1 Sub Total: Number; Formula: {Field 1 Qty} * 10
Field 2 Qty: Number
Field 2 Sub Total: Number; Formula: {Field 2 Qty} * 25
Grand Total: Number; Formula: {Field 1 Sub Total} + {Field 2 Sub Total}
The Grand Total field works on the front end, but gives zero in my Notification emails.
