Finance Format Number 💲

Danny Roden

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.

Finance Format Number.dmx

George_Stephen

Nice!

Please add a Percentage Format Number too. i.e. 0.0523 to be displayed as 5.23%

Danny Roden

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:

https://community.experianaperture.io/discussion/1222/percentage-functions

George_Stephen

Great! Thanks @Danny Roden