Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add ability to format as accounting values (in fmt_*() methods where it makes sense) #278

Open
rich-iannone opened this issue Apr 11, 2024 · 2 comments

Comments

@rich-iannone
Copy link
Member

We currently don't have the ability to format numeric values as accounting-type values (i.e., handling of negative values different than using the minus sign). This should ideally work inside:

  • fmt_number()
  • fmt_integer()
  • fmt_currency()
  • fmt_percent()

As for how it would look, this is a good start:

accounting_values
@JulianCologne
Copy link

Great Idea! 😃

Not sure if this is just to show the format but the "percent" value looks wrong 😄 .
Most programms (like excel, powerbi, ...) multiply by 100 and not divide by 10 😮 .

For example you perform a calculation resulting in 0.15 and formatted as percent yields 15% (1 = 100%)

@rich-iannone
Copy link
Member Author

I rescaled the number before applying the percent formatting (to put it in a better range).

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants