Change Number format in dynamic concat statement

sobo

I have create a concat statement to dynamically highlight a certain metric. Essentially it changes as the time period and other categories change.

The number is showing in the format in the above picture and I am hoping I could abbreviate in Billion or at least show the number in account format.

I would really appreciate some help with this.

Thank you!

brycec

You could divide the number in the Beast Mode such that it is represented in millions or billions, then append in the concat a label like mil. or in billions.

GrantSmith

using a CONCAT will make you number a string and will cause it to lose any formatting. You can do this via a beast mode. I’ve done write ups in the past on this depending on the format

Full number:

https://community-forums.domo.com/main/discussion/52677/domo-ideas-conference-beast-modes-number-formatting

Abbreviated version:

https://community-forums.domo.com/main/discussion/52685/domo-idea-exchange-beast-modes-abbreviated-summary-number

brycec

You could divide the number in the Beast Mode such that it is represented in millions or billions, then append in the concat a label like mil. or in billions.

sobo

I am going to implement this! I was hoping I wouldn't have to alter the ETL by adding a formula but I think that is the only way

GrantSmith

using a CONCAT will make you number a string and will cause it to lose any formatting. You can do this via a beast mode. I’ve done write ups in the past on this depending on the format

Full number:

https://community-forums.domo.com/main/discussion/52677/domo-ideas-conference-beast-modes-number-formatting

Abbreviated version:

https://community-forums.domo.com/main/discussion/52685/domo-idea-exchange-beast-modes-abbreviated-summary-number