Can someone help me with the formula used to convert this number format:   -1,125.6

to this format:  (1,125.6) <----with this in red.  Thanks in advance.

Hi Doug!

If it is always like that, to turn a negative number in a positive number, you can use the ABS() function. This function returns the absolute value of the given number. I am not sure how to turn it in red though.

Jakob

Here is what I use:

=NumberFormat({$_},"#,###;.

Your metric is defined as number such as this =NumberFormat({$_},"#,###.00") and you would want to change the format to currency format (=Currency($_,"#,###.00") to see the desired output "(1,125.6) <----with this in red" . This action I would do if I want this change to be reflected all over Apptio environment. 

However, if you are trying to change in a particular report as opposed to global metric then I would suggest creating a new variable in the report. Editing window of the new variable will allow you to define Currency format, as shown below. 

Regards,

Prem

Hi Doug,

 I'd use : =NumberFormat({ColumnName},"#,###.#;(#,###.#)",negColor="Red")

and if you want currency :

              =NumberFormat({ColumnName},"$#,###.#;($#,###.#)",negColor="Red")

Good Luck!

Martyn

Currency function  also could be used.

Is there any way data formatting can be applied at the UI layer i.e. in reports (charts and tables)? If yes, what are the steps to get that done?

I tried using this method in the model, but it did not work. 

NumberFormat({if statement with ColumnName or else blank},"#,###")

The number do not show up with comma separators. 

Any ideas? Suggestions

I found a way this can work. You can add a column to your table at the UI layer. There is an option under 'data' on the ribbon on the table. Once you add a column, you can format it such as it is a numeric type, specify if you want comma separator to be added and also if you want it round down. In the data column you can add the 'amount' or metric so it can be summed.