Update: after reviewing with @SatyamArora, he helped me understand that this is the correct way for rounding to work, especially with regard to inventory - would want to round to an integer item at the lowest level and then sum those values. I just wasn't thinking about it correctly. Some of my values in dashboards have not matched the screen shots in the L2 Sprint 3 training. In looking into these differences I noticed what I think is odd behavior for the ROUND function. I would expect that when rounding a value for a parent, the rounding would take place after all of the values are summed versus on each of the children values. Notice in this example for a given product and the parent of the account dimension that 2024 is rounded up to 2048, which didn't make sense to me until I looked at the details to see that 2048 is the sum of the rounded children values. Is this the correct behavior for ROUND?
... View more