Community
Q&A
Confluence
Questions
Confiform: Summing up values based on checkbox group choices

Confiform: Summing up values based on checkbox group choices

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

1 answer

2 votes

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)

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

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)

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Forums

Q&A

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

Confiform: Summing up values based on checkbox group choices

1 answer

Suggest an answer

Was this helpful?

Thanks!

TAGS

Atlassian Community Events