Format both positive and negative numbers in billions, millions, thousands and less than thousand

Hi guys, 

How do I format both positive and negative numbers in lookml. I want positive and negative numbers to be in Billion, Million, Thousand and less than that.

Current value_format_name option helps to define only up to 3 cases. I may need at least 8.

Billion(+),Million(+),Thousand(+),Billion(-),Million(-),Thousand(-),less than thousand as it is(+), greater than thousand as it is(-).

Can anyone help please?

0 0 192
0 REPLIES 0
Top Labels in this Space
Top Solution Authors