Confiform: Summing up values based on checkbox group choices

[Dan Behman]

Hello,

I have a confiform that has a checkbox group field with many different choices of task types. Each task type has a specific story point value (a number). I want to be able to calculate the total of all story points for the tasks that the user chooses (checks off in the checkbox group).

I've tried adding a Formula field named storyPointTotal with the following expression in it (simplified to just 3 for ease of illustration), note that task1, task2, task3 are the IDs and not the labels:

IF(NOTEMPTY("[entry.tasksForBuild:task1]"),5,0) + IF(NOTEMPTY("[entry.tasksForBuild:task2]"),6,0) + IF(NOTEMPTY("[entry.tasksForBuild:task3]"),5,0)

and then I display that field in my IFTTT macro that creates my JIRA epic, however I always get 0 regardless of what I choose in my checkbox group.

Any help would be greatly appreciated.

Thanks,
Dan

[Alex Medved _ConfiForms_]

Not sure I understand this completely but may be you need to do something like this

IF([entry.tasksForBuild.hasValue(task1)],5,0) + IF([entry.tasksForBuild.hasValue(task2)],5,0) + IF([entry.tasksForBuild.hasValue(task3)],5,0)

 (this assumes the tasksForBuild field has AT least one value selected)

[Dan Behman]

That works!!! As usual you're the best!!!!!

[Dan Behman]

Hi @Alex Medved _ConfiForms_  - I have a follow-on question to this as I extended some functionality ...

So thanks to your answer, my field called "totalPoints" which is a Calculated field now correctly sums everything up and the value gets put into a JIRA ticket.

However I want to now have that totalPoints value divided by 4.3 and put the result into a field called "totalDays". I've tried making totalDays a Calculated field and an Expression field with "totalPoints / 4.3" as the expression but no matter what, I get the wrong answer all the time..  For example, I get 11 for totalPoints and 37.6 for totalDays ...  

I've even tried doing an IFTTT with executing JavaScript to do the calculation that way but I get no value at all so I must be doing something wrong there too..  I just had a simple line of code like this:

totalDays = totalPoints / 4.3;

Any ideas please?

Thanks,
Dan

[Alex Medved _ConfiForms_]

It must be a formula field, not "calculated" and you will need to put a formula like

(IF([entry.tasksForBuild.hasValue(task1)],5,0) + IF([entry.tasksForBuild.hasValue(task2)],5,0) + IF([entry.tasksForBuild.hasValue(task3)],5,0))/4.3

or something like

[entry.totalPoints]/4.3

both fields should be formula fields, not calculate.. to react on changes (calculated fields are only calculated once on "create" and never recalculated)