Platform

Platform

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

 View Only
  • 1.  Number Format - Need Help

    Posted 09/30/19 05:31 PM

    Trying to make this work in R12 and I probably have the formula wrong (given my recent R11 hat). 

     

    I have a column that's called USD Amount w/the following logic =ConvertCurrencyFromBase(Entered Amount,Entered Currency,Currency Type). 

     

    That column results in just numbers with no commas - wanting to add commas to make it easier for folks to read it while they're in the transform.  Right now it looks like "XXXXXXXXX.XXX".

     

    So as not to break anything up/down stream, I rename that column to USD Amount Step1 and create a new column called USD Amount with =NumberFormat({USD Amount Step1},"#,###.###"), but it's not working.

     

    I checked the Formulas Step Order and it is processing it in the correct order with Step1 first.  What am I missing?

     



    #Platform


  • 2.  Re: Number Format - Need Help

    Posted 09/30/19 05:47 PM

    Numberformat only works on labels - do you have USD Amount set as a label or a numeric value?


    #Platform


  • 3.  Re: Number Format - Need Help

    Posted 09/30/19 05:51 PM

    THANK YOU!!  #facepalm moment.. ;-p


    #Platform


  • 4.  Re: Number Format - Need Help

    Posted 05/27/20 12:21 PM

    Not exactly this topic, but struggling right now with formatting numbers in an overlay report. Really arcane, on the verge of folklore (for me)!


    #Platform