Platform

Platform

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

 View Only

  • 1.  How to set the datatype to Decimal in CT

    Posted Mon October 03, 2022 12:27 PM
    Hi team,

    I want to setup the data type as decimal for the CT table . i see options as Char, int and Any.  How to set decimals. Will Any work as decimal and will not cause any issues when i use the same for Export table for my ITP.
    #TBMStudio


  • 2.  RE: How to set the datatype to Decimal in CT

    Posted Tue October 04, 2022 05:10 AM

    Hi,

    both "Text" and "Number" should work for this. To my knopwledge there's no data type restriction as what you might know from certain programming languages - in his regard Apptio is much simpler. Use "Number" if a column should sum up, use "Text" if it shouldn't (pretty sure this is a very simplistic view, but please correct me). 
    In your case you have to consider which type of decimal you want: "123.45" or "123,45". This is also what ITP cares about. So you may have to do some formula magic to replace one with the other or set the formatting in the CT import settings. But anyhow you should be able adjust this in the upload settings for ITP reference data.

    Hope this helps. 


    Original Message


  • 3.  RE: How to set the datatype to Decimal in CT

    Posted Tue October 04, 2022 05:38 AM

    You may be referring to the Import step, where you do get the ANY option. This is to tell CT what to expect:


    The columns in the table can only have alphanumeric, numeric or date. If you want decimal, pick number or A, as @Jonas Koch wrote.

    If you pick numeric, be sure that CT will understand the input format. Sometimes it does not accept something like 10,000.00 (it might not like the commas).

    ​

    ------------------------------
    Regards, Guillermo
    ------------------------------

    Original Message


Related Content