Does anyone have a list of Calculations and Formula parameters and examples that can be used in the Calculation field type. The current User Manual has nothing!
-
Posted 3 months ago #
-
Hi Tmerwick,
There's not much to it right now. You just pick a field, pick an operator, enter in a value, use some brackets, pick another field, etc. This lets you build up a formula such as:
Total = [Price] x [Quantity]
or with tax:
Total = [Price] x [Quantity] x 1.0.5
Where [Price] and [Quantity] are the names of the fields you'd like the calculation to based upon. The x will show up as an asterisk in the formula. But I just put it as an x here for clarity. "Total" is the name of the calculation field itself.
Hope that helps!
Thanks!
Brendan
Posted 3 months ago # -
Thanks Brendan! Math 101!
Posted 3 months ago # -
Brendan, it would be very useful to me to be able ti use the result of another calculation field in another calculation. I noticed that calc fields are not available for calculations. Thanks
Posted 1 month ago # -
Sorry I just saw this answer in another thread. Thanks.
Posted 1 month ago #
Reply
You must log in to post.