NUMBER_FORMAT function

JasonAltenburg
JasonAltenburg Contributor
in Beast Mode

Please consider the implementation of a NUMBER_FORMAT function in Beast Mode in the same vein that we have DATE_FORMAT and TIME_FORMAT. This would take a number, and based on parameters, format the number (add thousand separator commas, percent sign, currency sign).

Numerous discussions have been had in the forums about how to use Beast Mode to add commas, dollar signs, percent signs in summary numbers, or in table cards.

As much as I love @GrantSmith a 67 line beast mode to add thousands separator commas feels like a workaround of a solution to a relatively common problem. In addition, I have had to write even more cumbersome Beast Mode statements to satisfy requests when working with the Variables Product when for example, one metric is a currency and the other is a percentage.

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

Tagged:

Comments

  • MarkSnodgrass
    MarkSnodgrass Coach

    Love the idea @JasonAltenburg ! I think you intended to make this something for the ideas exchange, but it is just showing up as a regular discussion.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Categories