Hi, I’m trying to do a PNL report with actual vs budget with variance amt and % columns. I have set the formula in the column set like this:
However, the result doesn’t seem to be consistent. Like this highlighted value:
The result doesn’t seem to match with the formula I have set. In fact, I’m confused about how it arrived at that amount. But the one in the 3rd row is correct. There seems to be inconsistency. Does anybody knows about this?
