Hi Lars,

With sample data, I created a financial statement that had both UM and {1}UM as columns on a SmartSheet. Account 4000 has statistical units for years 2008, 2007 and 2006, so this is good to test with. For account 4000-100 and year 2008, period 10, I can correctly see a value of 21.00 for the UM formula, and 16.00 for the {1}UM value. Same if I collapse the SmartSheet and consolidate all departments for account 4000. So in these examples, {1}UM is not reporting the same value as UM.

I presume you have sent data and the spec to Andrew, based on your comments.