Hi all, The average activity in microflow has incosistent behaviour. I retrieve a list from database, aggregate the same list, take average of the attribute score. For example 6 6 6 3 6 6 6 6 6 / 9 = 5.6 but the outcome is 5.8 If the outcome is a round number then it's correct. So, 4 4 4 4 4 / 5 = 4. Does anybody know what caused this?
asked
Shantila
1 answers
1
On which database do you work? Postgres?
Did you try to aggregate via SQL? If so, what was the result?
If you don’t have direct access to the database, you could also try to do an ggregation with OQL and compare your results.