Platform

Platform

 View Only
  • 1.  Number Format - Need Help

    Posted Mon September 30, 2019 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 Mon September 30, 2019 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 Mon September 30, 2019 05:51 PM

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


    #Platform


  • 4.  Re: Number Format - Need Help

    Posted Wed May 27, 2020 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