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?