Column Header as Billions

[BRRLL99]

Hi Team,

I would like present my columns >>Sales, Profit, Assets, Market value into Sales(Billions),profit(Billions) etc.,

Few rows in the columns have Millions(M). Please let me know how can I convert those million values into Billions. Since some values have negative millions.

Dataset has been attached

sort, Multi-Row Formula,

[tandon · Accepted solution]

Hi, can we alter column heading and add Billion i.e. Sales (in B) rather then adding "B" in every cell? Also, wherever it's Million, it can be converted to B by dividing to 100. 

[DataNath · Accepted solution]

How does this look @BRRLL99? Formula:

if contains([_CurrentField_], 'M') then '$'+tostring(tonumber(REGEX_Replace([_CurrentField_], '[$M]', ''))/1000)+ ' B' else [_CurrentField_] endif

Before:

After:

[BRRLL99]

Hi,

Billions can be converted into millions by dividing 1000.

Please go through profit column (example)

company	profit
Apple	63.9 B
Core -Mark Holding	63.2M
Mustachio Bank	60.6M

how can i divide String 63.2M OR 60.6M with 1000?

only if last character is "M"

[binuacs · Accepted solution]

@BRRLL99 one way doing this

[BRRLL99]

thq