Concatenate for sum
Hi
The notice says that to get the sum of a numbers that are inside the fields one have to use "concatenate" in the filer box and choose between sum -average- minimum -maximum.
When I click on "concatenate" I do not see sum- average- minimum -maximum.
Where should I find them ?
Thanks
7 replies
-
-
what is a filer box?
You can only use sum, average, min, max on arrays so you need to first take our list of numbers then you can concatenate them then you need to split them into an array. then you can sum, avg, min, or max.
for example:
field1:
let x := (select Table1).testNumber;
let conX := concat(x);
split(conX, ",")field2:
sum(field1)
-
sorry, i didn't see the picture.
-
No filer but filter…
What is an array ?
-
Hi Fred
Thanks
I do not understand the use of this button "concatenate".
Does it launch a formula ?
-
You are misunderstanding the manual. Concatenate is just one of the options available to show at the bottom of the columns in a list view. You are not seeing the options of Sum, Average, Min, Max becasue these are only available for numeric data types.
Non Numeric Data Types - Count, First, Last, Concatenate
Numeric Data Types - Count, Sum, Average, Min, Max, First, Last, Concatenate
Regards
John
-
Ok Thank you John.
Content aside
- 3 yrs agoLast active
- 7Replies
- 528Views