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