IBM Apptio

Apptio

A place for Apptio product users to learn, connect, share and grow together.


#Aspera
#Apptio
#Automation
#FinOps
#Apptio
#ITAutomation
 View Only

  • 1.  SUMPRODUCT Equivalent Function in Apptio

    Posted 03/17/23 11:34 AM

    Hello Team,

    I have a use case where I want to use SUMPRODUCT (in Excel) like function in Apptio Cost transparency.

    Does Apptio have a similar or equivalent function which can do the calculation?

    Need help!


    #CostingStandard(CT-Foundation)


  • 2.  RE: SUMPRODUCT Equivalent Function in Apptio

    Posted 03/17/23 11:52 AM

    Hello,

    https://help.apptio.com/en-us/studio/formulas-and-functions/functions/functions.htm 

    Have you tried looking for something in this area?




  • 3.  RE: SUMPRODUCT Equivalent Function in Apptio

    Posted 03/21/23 05:56 AM

    Hey Srinivasan,

    this function itself is not available to my knowledge. You might want to replace with a helper column that calculates the product for each row, and then sum that one up with SumIf.