Apptio for All

 View Only

 Number formatting in report

Jump to  Best Answer
  • ApptioforAll
Apptio Community Member's profile image
Apptio Community Member posted 07/04/22 07:55 AM
Hi, I have a custom report with a few columns including one that is stored as a # in the model. It contains values such as 0.23,  0.14, 0.06 etc. I want to display this column in the report as a %age so that instead of 0.23 I would see 23.0%  and so on, how could I go about doing that? ​
#ApptioforAll
Jenny Franklin's profile image
Jenny Franklin posted 07/04/22 11:00 AM  Best Answer
Apptio Community Member updated 07/04/22 11:02 AM
Hi @Nathan Bennett,

Since it's in a report, I would add a ​formula column to get there.

With the report table selected, go to Data in the ribbon above, and then select Insert Formula Column...


Then a window will appear where you can do the math...


And that'll do it...


#ApptioforAll
Guillermo Cuadrado's profile image
Guillermo Cuadrado posted 07/05/22 03:05 AM
Hello, @Nathan Bennett.
@Jenny Franklin's solution is perfect for your case, we use that very often.
It would also work if you want to change the format in other ways, e.g. ​if it were a currency, ​displaying it as millions, etc.
#ApptioforAll

Related Content