Quick Question... hopefully.

Does anyone know how to remove the dollar signs from a new column created using the "value field settings" option in the AdHoc reporting tool? I'm trying to create columns within a table for LM, YTD, and, QTD volume counts, and it keeps showing up as dollars. I don't see anywhere to change it. Should I just add a numberformat in the formula bar?

Thanks!

You're right - using the Value Field Settings does not always respect whatever formatting decision is in place (in the case of a metric), and the result can be a dollar sign in the report table.

Assuming Volume is a metric in your project, you could try bypassing the Value Field Settings in this case and instead construct your three table columns using Ribbon > Data > Insert > Insert Formula Column.

To generate your three columns above:

LM Volume V2 = TimePeriod(Volume,-1)

YTD Volume V2 = YearToDate(Volume)

QTD Volume V2 = QuarterToDate(Volume)

...the formatting of these three columns is controlled by the settings seen in the column creation dialog.

After typing the formula above, you can select a format of Number and 2 decimal points to match the format settings of the original metric.

One way I have approached this in the past is by inserting a new formula column with the same name as the original column and then set the format of the new column as number instead of currency. If  two columns have the same name in the report, Apptio will display the last created one. For instance, if you want to have the LM Volume without $ sign, you insert a new formula column called LM Volume and set the formula as (=LM Volume) with the format being number. I use this a lot when I report on transform tables.

Or, if the your column is a metric in your project, you can adjust the table format in the metric setting.