We have a scenario where a department owner did not plan for any costs in a cost pool (in this case External Labor) - and now they have operating expense showing up. This in and of itself is not really a problem but in Apptio, the OpEx Budget Variance % column is reporting zero. I recognize the mathematical problem here but the end result is that you see the same result for a no budget situation as you do to an exactly budget situation.
Has anyone else encountered this situation? Do you have a work-around to suggest?

#CostingStandard(CT-Foundation)

@Robert Krauss, I assume the OpeEx Budget Variance % is a calculated column you put in a table. Can't you not put a "IF..." statement to account for the scenario you described to exclude the non plan item?​

------------------------------
Tony Wong
ExxonMobil TBM Analyst
------------------------------

@Tony Wong - if this was a custom report, that is exactly what I would do. But this in the OOTB Financial Review report, which gives me pause when I consider tinkering!​
Original Message:
Sent: 07-18-2022 11:01
From: Tony Wong
Subject: Budget Variance % and a zero demoninator

@Robert Krauss, I assume the OpeEx Budget Variance % is a calculated column you put in a table. Can't you not put a "IF..." statement to account for the scenario you described to exclude the non plan item?​

------------------------------
Tony Wong
ExxonMobil TBM Analyst
------------------------------

@Robert Krauss, then all you to have to do is make a copy of this OOTB report for future component upgrade rollback. Then adjust the necessary column to fit your need. When it's time to do content upgrade, you can re-use this copy when the revert wipes out your changes. Does this make sense? We do this all the time to override the OOTB report (although Apptio always warn against it because the content upgrade process will revert all your custom changes; but this is how we resolve this).​

------------------------------
Tony Wong
ExxonMobil TBM Analyst
------------------------------

Original Message:
Sent: 07-18-2022 11:06
From: Robert Krauss
Subject: Budget Variance % and a zero demoninator

@Tony Wong - if this was a custom report, that is exactly what I would do. But this in the OOTB Financial Review report, which gives me pause when I consider tinkering!​

Original Message:
Sent: 07-18-2022 11:01
From: Tony Wong
Subject: Budget Variance % and a zero demoninator

@Robert Krauss, I assume the OpeEx Budget Variance % is a calculated column you put in a table. Can't you not put a "IF..." statement to account for the scenario you described to exclude the non plan item?​

------------------------------
Tony Wong
ExxonMobil TBM Analyst