Skip to Main Content
Cloud Management and AIOps


This is an IBM Automation portal for Cloud Management, Technology Cost Management, Network Automation and AIOps products. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).

Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:

Search existing ideas

Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,

Post your ideas
  1. Post an idea.

  2. Get feedback from the IBM team and other customers to refine your idea.

  3. Follow the idea through the IBM Ideas process.

Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.

ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

Status Under review
Workspace Apptio
Created by Guest
Created on Nov 24, 2023

Restrict addition of Percentage columns in Apptio -Non-summable

We have an option to restrict row totals in Apptio for any field (By selecting Summable/Non-summable option in the formula ). But the same option is not working fine when the column total is happening. Percentage values cannot be summable, the calculation need to happen at the respective group level

E.g. 

Excel example of an expected behavior and scenario:

  1. Note the behavior for Total = calculations happen at an individual row /column level . Percentages are not added like how numbers are added

 

 

Q1 FY 2024

Q2 FY 2024

Total Views

Data

Ac

For

Var

Var %

Ac

For

Var

Var %

Total Ac

Total For

Total Var

Total Var %

Data 1

10

35

25

250%

40

25

-15

-38%

50

60

10

20%

Data 2

25

10

-15

-60%

25

10

-15

-60%

50

20

-30

-60%

Total

35

45

10

29%

65

35

-30

-46%

100

80

-20

-20%

 

Apptio example of above scenario

  1. Note the Var % total for Q1 and Q2 is happening correctly in Apptio, but The Total Var % is adding Var % which is wrong , we only want to resolve this
  2. E.g., how can variance be 213% for first row ? when variance should be 10/50 = 20%. It is not logically, correct ?
  3. Note in Apptio the Q1, and Q2 totals for Var % is showing expected behavior which is correct

 

 

Q1 FY 2024

Q2 FY 2024

Total Views

Data

Ac

For

Var

Var %

Ac

For

Var

Var %

Total Ac

Total For

Total Var

Total Var %

Data 1

10

35

25

250%

40

25

-15

-38%

  • ADMIN RESPONSE
    Dec 9, 2024

    I understand the feature request and have added it to the product backlog.  We will review and prioritize against other feature enhancements.  I also moved this to the TBM Studio category since it is a platform feature that works across all content.