Adding up values associated with checkbox items
I have the following issue:
A record has a field with several checkboxes.
The checkboxes draw their values from a a value list with custom values, which are just that: Irrigation, Toilet, Other.
I would like to assign numeric values to them so that Irrigation is 0.2, toilet is 0.5, and other is 0.3.
Then I'd like to create a new field in the same table to add up the numeric values of the boxes that get checked.
What is the best way of going about it? Are my checkboxes set up appropriately?
Any advice and guideance would be highly appreciated.