Why does aggr() work fine around COUNT() - but not around SUM()
I wonder if there is any simple answer to this:
- In all of my apps, there is a chart "presence_quota" which is always the same - well, mostly:
- The HR_app has a formula with COUNT() to calculate the nr. of employees
- all others have a formula with SUM()
=> I guess I did not have the time to make them all equal as it does of course require some work in the script.
Now, in my HR_app, when one changes the dimension from day to month, there is a copy of the formula with aggr() - so it's aggr(Count([something]))
<=> in all the other apps, that didn't work, the figures are wrong as yet, so I developed a code to determine the nr. of workdays in any month and divide the total sum() by that. That then is a pretty good approximation.
<=> In the HR_app, on the other hand, that approach doesn't work at all.
The only thing I can imagine right now is that it has to do with the difference of Count() vs. Sum().
Can anybody explain that to me? Is there any general principle for this?