PLEASE NOTE: These forums are no longer utilized and are provided as an archive for informational purposes only. All support issues will be handled via email using our support ticket system. For more detailed information on this change, please see this blog post.

BUG? Formula field values wrong in Notification emails

  1. 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.

    Posted 9 years ago on Wednesday May 15, 2013 | Permalink
  2. There is an update going out today (1.7.3) that will fix this issue.

    Posted 9 years ago on Thursday May 16, 2013 | Permalink
  3. Any solution!?!?!
    The same problem
    help please!

    Posted 9 years ago on Friday May 24, 2013 | Permalink