Hello, after go-ive we started to recognize that all calculated "Total Variances %" in rows are wrong. Apptio is just summing up the variances % per row which is wrong. Correctly calculated the total variance % should be based on the total sums in rows.

We are running CT Version r12.5.1.1. I checked the reference application we can access which has CT Version r12.6.2a and there the issue seems resolved.

I was not able to open the reports in the reference application to see how this is fixed.

Anybody any idea what can be done?

Attached examples our application vs reference applicaiton.

Very grateful for any hint.

Michael 

Michael Zimpfer,

Summing of %figures is just plain wrong.

Assuming this is a calculated column on a report, two things I would check are:

1) The "Summable" check-box is not accidentally checked in column properties (it should be unchecked).

2) The other columns or metrics on which the formula is based are also not summable.

Also, please reach out to your Apptio CSM -@Stephen Zeronian-Dalley for this.

thank you! I will check this out

Hi Michael,

Short answer: This is something that has been fixed in later version as you saw when you checked the reference application that was on CT Version r12.6.2a.

So I'd recommend just getting upgrading to the latest version and you should see this work correctly.

Longer answer:

In r12.5.1.1 this report is using If statements in the Budget Variance % calculation formula. e.g If(Budget=0, 0, BudgetVariance/Budget)
As I understand right now this can cause issues with totals to calculate as a Sum as you saw despite the Summable box not being ticked.

In later versions this looks like its been fixed by (as shown in Jaitabh's screenshot) updating the formula to no longer make use of the If statement but rather use 0+ instead to handle the possibility of a 0 divisor.

Cheers,

Mandy

Hi Mandy,

thanks for that comment. I got the same information almost at the same time from Apptio support

Have a good week ahead.

Br,

Michael