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 ValueView - Wrong calculation

Michael Küng

Hey,

I have an easy calculation within a ValueView.

<ac:parameter ac:name="fieldName">Required:(20-([entry.actual]))</ac:parameter>

The calculation is 20 minus the sum of the field actual by ([entry.actual]).

It works if I have only one entry, eg. one entry with a field value of 4, iI got 16 with the term above. If I have two entries, eg. with field values 4 and 2 =6, I got a result of 34 instead of 14.

Is there a fault in my thinking or is this a bug?

Thanks in advance.

Accepted answers

Alex Medved _ConfiForms_

Hi @Michael Küng

Calculation are made PER ROW, and then aggregated by "key" (summed up)

Alex

All comments

Alex Medved _ConfiForms_

Hi @Michael Küng

Calculation are made PER ROW, and then aggregated by "key" (summed up)

Alex

Michael Küng

Okay, so...in my example: (20-4)+(20-2) = 34

And I guess there is no way, to calculate with the "summed up" value?

Alex Medved _ConfiForms_

Well, there is... but it is a bit weird :-)

Required:(20 [entry.id.queryAndSet(form:@self;*;actual.prepend(-)).split(,).join()])

Little demo:

http://recordit.co/URFHYXhVR6

PS, my ValueView is set to LIMIT itself to 1 record

Alex

Michael Küng

What the hell?! You are a genius! Thanks

I feel like I was dived deep into a rabbit hole,. Don't got the solution at all, but it works

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