We are working on creating different visualizations in Apptio BI and want to create a custom calculated metric comparing Opex Budget against Opex. The desired result would be to have a percentage variance appear displaying either an over or under run (positive or negative value). We are running into some issues with the percentage variance showing as N/A due to the Opex Budget not having dollars on the rows/fields that have just Opex. I tried to "flip" the metric to compare Opex against Opex Budget and am having the same issue as we have some rows/fields with no Opex when there is an Opex Budget.

Ideally, we would want the N/A to show a 100% variance either because Opex exists but no Budget exists OR because Budget exists but no Opex exists (for the pre-selected dimensions). Apptio BI shows the change in a dollar format, but not the percentage format.

Any help would be greatly appreciated if this can be formatted directly in BI or if something perhaps needs to be done in TBM Studio or if this is even possible. Thanks!