Sum of function


I have been working on visualizing data from a schedule using the “sum of” build-in function.

Within a loop that counts the days of a year, I check how many weeks already exist also every Monday I create a new week. To check, the application uses the build-in function: “sum of” with the id. My question is: does the function sum the number of ids that exist or sum the numbers of all the ids. for example, the function calculates how many ids there are (1+1+1+1+1) or all the ids combined (1+2+3+4+5)?

I hope my question is clear!

Kind regards,

Albert Wemmers

1 Like

Hi Albert,
Sum of A will add them all up, so 1+2+3+4+5
If you want to count the number of items you can use the function Count items in list A (almost at the bottom of the list when you select a function).

We also have some articles in our knowledge base regarding dates and number:

If you need additional help, please let me know.


Ah this explains my problems, thank you!