vaughan
Member
Hi
I have a calculation element plugin, it SUM 3 fileds:
field1=dropdown with 4 values
field2=multiselect checkbox with 4 values (each value=30)
field3=Checkbox with 1 value
I want to SUM this 3 fields with the user selections and works fine, but only when field2 choose only 1 value, if users select 2 or 3 values in checkbox (field2) only SUM 1 value
My calculation is
return '{tablename___field1_raw}'+'{tablename___field2_raw}'+'{tablename___field3_raw}';
How can I do to SUM the values in field2 when a user choose some values?
For example
field1=60
field2=30+30+30
field3=40
Total=190, but in my calculation SUM 130 (only SUM 1 selection in field2)
Thanks for your help
Best regards
I have a calculation element plugin, it SUM 3 fileds:
field1=dropdown with 4 values
field2=multiselect checkbox with 4 values (each value=30)
field3=Checkbox with 1 value
I want to SUM this 3 fields with the user selections and works fine, but only when field2 choose only 1 value, if users select 2 or 3 values in checkbox (field2) only SUM 1 value
My calculation is
return '{tablename___field1_raw}'+'{tablename___field2_raw}'+'{tablename___field3_raw}';
How can I do to SUM the values in field2 when a user choose some values?
For example
field1=60
field2=30+30+30
field3=40
Total=190, but in my calculation SUM 130 (only SUM 1 selection in field2)
Thanks for your help
Best regards