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.
Okay, so...in my example: (20-4)+(20-2) = 34
And I guess there is no way, to calculate with the "summed up" value?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Well, there is... but it is a bit weird :-)
Required:(20 [entry.id.queryAndSet(form:@self;*;actual.prepend(-)).split(,).join()])
Little demo:
PS, my ValueView is set to LIMIT itself to 1 record
Alex
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 :D
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes, use with caution.. it is a bit weird expression :-)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.