This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
html:{% if value >= 1000000 and value < 1000000000 %}${<!-- -->{value |
divided_by: 1000000 | round:1 }}M{% elsif value >= 1000 and value <
1000000 %}${<!-- -->{value | divided_by: 1000 | round:1 }}K{% elsif value >= 0
and value < 1000 %}${<!-- -->{value | round:0 }}{% elsi<!-- --><!-- --><!-- -->...
To Google Looker FolksNeed Value format for negative numbers.I was
trying this : value_format:
"[>=1000000]0.0,,\"M\";[>=1000]0.0,\"K\";[>=0]0;[<=-1000000]-0.0,,\"M\";[<=-1000]-0.0,\"K\";-0"
but it was not working. Any Insights on this? Appreciate it...