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.  Creating 'YTD Unassigned' field

    Posted 05/16/17 07:10 PM

    Has anybody ever added/created a 'YTD Unassigned' column to report tables?  How can this be done?  Can a .Unassigned table have this kind of column?






    #CostingStandard(CT-Foundation)


  • 2.  Re: Creating 'YTD Unassigned' field

    Posted 05/17/17 04:22 AM

    Hi Karen,

     

    this is a much discussed topic, and unfortunately the simple answer is no we can't have a YTD Unassigned table. The options are to have a single month and scroll through, create two tables that shows the starting object costs and the destination object cost (filtered to only include costs from the first object) and view the delta.

     

    Sorry, not a great answer

     

    Michael


    #CostingStandard(CT-Foundation)


  • 3.  Re: Creating 'YTD Unassigned' field

    Posted 05/17/17 07:10 AM

    Thanks for the info Michael!  This is another option on top of one I found here in the boards (https://tbmcouncil.jiveon.com/message/3075 ).


    #CostingStandard(CT-Foundation)


  • 4.  Re: Creating 'YTD Unassigned' field

    Posted 05/17/17 12:00 PM

    I was about to add that  - that's the best way I've found is to add the months to it.  You can also edit the trend to show multiple months (I think the default is 6 months past, 6 months future) by going to the Author tab, then Properties, then the Trend area.

     


    #CostingStandard(CT-Foundation)


  • 5.  Re: Creating 'YTD Unassigned' field

    Posted 05/17/17 12:06 PM

    And this is the report we use on our end: Validation Helper 


    #CostingStandard(CT-Foundation)


  • 6.  RE: Creating 'YTD Unassigned' field

    Posted 05/19/21 03:48 AM
    I can't seem to find a .Unassigned table. Was this an R11 thing? @Jenny Franklin​​


  • 7.  RE: Creating 'YTD Unassigned' field

    Posted 05/20/21 09:36 AM
    Hey @Guillermo Cuadrado!  Yes, the validation table used hidden tables and those were in R11, but I did find out how to do it in R12 - I just haven't documented it.  Will get that out there today!!


  • 8.  RE: Creating 'YTD Unassigned' field
    Best Answer

    Posted 05/20/21 12:07 PM
    @Guillermo Cuadrado and @Karen Lim - give this a whirl.. https://community.apptio.com/blogs/jenny-franklin1/2021/05/20/r12-fallout-report ​​