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.

Multiple Formulas in a single Calculations field?

  1. I am attempting to add a field that totals variable calculations based on user input. For example, if a user selects the variable "Swimming," I have successfully implemented the single formula:

    {Minutes Swimming:5} * 3

    However I would like to add another formula that would tabulate the total if the user selected a different variable (Walking, Running, etc...).

    I tried this:
    {Minutes Swimming:5} * 3
    {Minutes Running:6} * 5
    {Minutes Walking:7} * 2

    But that seems to be incorrect...and I am not sure it is even plausible. The desired end result is a total based on a single selection, not a compounded total.

    Any ideas?
    TIA
    ~Rat

    Posted 12 years ago on Tuesday November 13, 2012 | Permalink
  2. David Peralty

    Can you give me a screenshot of what you have? If you have put what you have above, in one calculation field, then it wouldn't work. Because you've tried to put three calculations in one field. If you wanted to add those values together, with a plus symbol, then that would work. But as it is currently, you would need different calculation fields to get a result.

    Posted 12 years ago on Tuesday November 13, 2012 | Permalink
  3. David,
    What you see above is what I tried to use...

    If I understand correctly, there can only be one complete calculation per field? If so, then can the Admin Label be duplicated to the entries could all be viewed in one column?

    Posted 12 years ago on Tuesday November 13, 2012 | Permalink
  4. David Peralty

    As I'm sure you've already guessed, while you can have the same label for fields, they'll also be given unique field numbers, which means they won't be shown in one column in the back end.

    Posted 12 years ago on Tuesday November 13, 2012 | Permalink