IBM Data & AI

Welcome to the idea forum for IBM Data & AI (Formerly Analytics) Clients! 


IBM Employees:

The correct URL for entering your ideas is



Our team welcomes any feedback  and suggestions you have for improving our offerings / products!  This forum allows us to connect your offering / product improvement ideas with IBM product and engineering teams.


If you have not registered on this portal please click on the following link and register.  To complete registration you will need to open the email you will receive from Aha to confirm your identity.


Need to calculation a summary value for calculated ratios based on calculations and not by average in Dashboard

If we create any ratio calculations in the dashboard by default the resulting value is summed up, which is wrong. Also, if we change the summary property to average then it is giving a value which is nearly right but we are not getting the exact value. I have attached below the document for your reference and understanding. 

  • Mohammed Asim Ansari
  • Apr 24 2019
Why is it useful?
Who would benefit from this IDEA? while viewing dashboard all the values shown in dashboard will be accurate and reliable
How should it work?
  • Taking this scenario into consideration the premium amount is 2,535,550,000 and Sum Ensured is 5,685,550,000.
  • While the premium is divided with Sum Ensured, the value we are getting is 0.43 which is the average value of the calculated item.
  • Actual value should be 12,564,341,000/ 26,716,841,000 = 0.4702.
Idea Priority High
Priority Justification Need to improve efficiency in calculation
Customer Name Veracitiz solutions pvt ltd
Submitting Organization
Submitter Tags
  • Attach files
  • manpreet singh uppal commented
    24 Apr 07:11
    Need to improve efficiency in calculation

NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "anonymous@euprivacy.out" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions