Is anyone able to assist me aligning the numbers in column RN/ GI Bedr. to the right? I assume this should be done in the yellow marked box but when I enter the following HTML code, Apptio returns errors

<span style='align:right'>

Still sipping coffee, but if you choose Number instead of Advanced and Number instead of Label, would that work?  I'm also not in R12 yet..

Thank you for your reply. Unfortunately, this doesn't give the required result.

@Menno Wittebol,

Try with the following changes:

1. Remove quotes either side of 9999 in your formula. (i.e. "9999" just 9999)
2. For Format field, select Number 
3. For Type field, select Number/Numeric instead of Label.
4. Click Update
5. Save report.

Great advice @Jaitabh Jewel Sharma, it worked. However, the result is not shown immediately. The full instruction in this case is as follows:

1. Remove quotes either side of 9999 in your formula. (i.e. "9999" just 9999)
2. For Format field, select Number
3. Remove the Use Grouping Separator and update the Decimal Places if required
4. For Type field, select Number/Numeric instead of Label.
5. Click Update
6. Save report

At this moment the required alignment is still not visible. To see the final results, close and reopen your report.

Hi @Menno Wittebol,

Formatting is also described in this document:

https://tbmcouncil.jiveon.com/docs/DOC-1068

The code is as follows:

="<div align='center'>" & IF(....) & "</div>"

Also this way you can search for {various} in a all numeric field.

Robert

Hi @Robert Brilmayer, great support. This is a much better and also working solution because of the search for various option that will stay as required option. Thanks!

Hi Menno,

I tried to take stab at this, to build up on the initial syntax which you had proposed, and I was able to get it "Right Aligned"

So, in the formula, I had to account for the " Column Name"

Thanks and Regards

Varghese George