COLLAPSEALL not working for smaller numbers in a Visual Calculation
I've been trying to write a visual calculation formula, but I've noticed that for smaller numbers it doesn't work as expected. I've been able to pin the problem to COLLAPSEALL behavior. It basically stops working for smaller numbers in my table. It works well for many rows, but when it reaches values smaller than 0.01% of the column total, the Total column shows the row value, instead of the expected Total value (collapsed column total). The test formula is as simple as this: Total = COLLAPSEALL([Value],ROWS) The screenshot shows a data sample, where it breaks (rows sorted by value, descending).
