Formalae for Summing products selected
I currently have a Multiple choice field (Show as Radio Buttons) where the staff can select multiple products that the clients has chosen to Purchase.
Hammer - $5
Spanner - $3
Nails - $10
What formalae should i use to sum up the total cost of the selected products
example the 1 customer bought a hammer = total cost $5
another customer bought a hammer and nails. = total cost $15
Ive been trying if functions but can't seem to wrap my head around it.
It depends ...
I'd propose to use a dynamic multiple choice (DMC) field 'Multiple Choice' in one table. Then you store your products in another table 'Products'. 'Products' has at least two fields, 'Name' and 'Price'.
For the DMC, you use "select Products" as dynamic value in the config popup. As name of the dynamic value, you select 'Name'.
The total is then
let prods := numbers('Multiple Choice'); let total := 0; for i in prods do total := total + record('Products',number(i)).Price; end; total