Hi Andrew

It turns out that in this instance, those functions don't work. The row in question is actually consolidating two GL accounts, and when the balances in the two accounts go in opposite directions, it only reports the one with the higher absolute value instead of the net, which throws the balance sheet out of balance.

I figured out a less elegant way to do it, using an IF statement.

When I asked how I might learn about this and other cool features, I didn't envision having to read in Help how each function works. Those are the rules. What I want is the strategy. Yes, I can ask for a strategy on the forum, and I don't mind doing it. I was just hoping there was some other tool.

Steve