Finance Format Number 💲
Danny Roden
Administrator
Summary
This package contains a single function but may be updated in the future to include others.
Finance Format Number 💲
Suggested by @Sharat Kutty, this function converts Negative numbers are put it in brackets so the number i.e. -100.23 becomes (100.23) and shows up as Red color. All 0 and above shows in normal color.
See below for preview of the function definition logic and some sample output results:
Compatibility:
These functions are compatible with all instances of Data Studio from v2.12.8 onwards.
1
Comments
-
Nice!
Please add a Percentage Format Number too. i.e. 0.0523 to be displayed as 5.23%
0 -
Thanks for the suggestion @George_Stephen, I've just had a quick stab at this on the train this morning. See here for more information:
1 -
Great! Thanks @Danny Roden
0
