nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Confiforms - Sum task effort in a summary page

François-Xavier Collet_w571m6

I probably missed something big,... but I'm not able to find a way to sum Confiforms field in a summary page.

I have Confiform "Task" form containing records. One of the "Task" field is "Effort" and another one is Project page ID "ParentProject".

On the Project page, I have table vew showing all the tasks of the project filtered by "ParentProject". --> This works well unsing a Confiforms TableView.

On this same page I would like to have a project overview showing the total effort of all the tasks linked to the project.

Can someone help me with this?

If I use a ValueView, I can list all the efforts linked to the project filtered by "ParentProject"(something like "2 4 7 1") but can't sum those value.

Any input welcome.

Thanks

Xavier

Accepted answers

Alex Medved _ConfiForms_

With ConfiForms ValueView you can use the expression inside the field name and that is done the same way as you will do it in a TableViewMerger fields

Some field:([entry._here_field_name_to_sum_])

All comments

Alex Medved _ConfiForms_

With ConfiForms ValueView you can use the expression inside the field name and that is done the same way as you will do it in a TableViewMerger fields

Some field:([entry._here_field_name_to_sum_])

François-Xavier Collet_w571m6

I'm not able to get the sum out of the ValueView...

I got this result... Which is the different effort for each tasks. total should be 10...

Regards

Xavier

Alex Medved _ConfiForms_

Do you want the sum of 1+2+3+4 or the count?

for sum

Tasks sum:([entry.TskOnSiteEffort])

for count

[count]

Count:([count])

François-Xavier Collet_w571m6

Almost there...

If I use:

sum:([entry.TskOnSiteEffort]), I get no value

If I use

sum:(TskOnSiteEffort) I got a value but the sum is a little strange...

If I have 2 tasks, it sum all the task 2 times... Task 1 (effort 1), Task 2 (effort 2) result is 6

If I have 3 task, it sum all the task 3 times... Task 1 (effort 1), Task 2 (effort 2),Task 3 (effort 3) result is 18

Total on-site effort:
<ac:structured-macro ac:name="confiform-value" ac:schema-version="1" ac:macro-id="6036a2ea-310f-477f-991e-dd6d1a29581a">
<ac:parameter ac:name="filter">TskParentPrj.PrjPage.id:509455602</ac:parameter>
<ac:parameter ac:name="fieldName">TskOnSiteEffort</ac:parameter>
<ac:parameter ac:name="pageTitle">
<ac:link>
<ri:page ri:content-title="CFTask" />
</ac:link>
</ac:parameter>
<ac:parameter ac:name="formName">CFTask</ac:parameter>
</ac:structured-macro>
should be = to
<ac:structured-macro ac:name="confiform-value" ac:schema-version="1" ac:macro-id="7a1b8601-dbef-4dfe-9dcf-bb23ec590fbf">
<ac:parameter ac:name="filter">TskParentPrj.PrjPage.id:509455602</ac:parameter>
<ac:parameter ac:name="fieldName">Sum:(TskOnSiteEffort)</ac:parameter>
<ac:parameter ac:name="pageTitle">
<ac:link>
<ri:page ri:content-title="CFTask" />
</ac:link>
</ac:parameter>
<ac:parameter ac:name="formName">CFTask</ac:parameter>
</ac:structured-macro>

With this code I get the bellow results...

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server

confiforms