Answered

Last two cents in currency need to hidden

(0) Share

Report

Posted on by stevenpetersmi

207

Hi

I'm hoping you can help me. I'd like to find any hidden cents in this column rather than having them display as zeros.

I've tried modifying the currency settings, but none of them seem to show the hidden cents. Do I need to access the Power Platform admin settings to resolve this issue?

Thank you.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

pavanmanideep 495 Power Up Champ - 2025 on at

Like (0)

Report

Hi @stevenpetersmi

You can change the default formatting for number columns, refer to https://recursion.no/uncategorized/dataverse-remove-decimal-format-from-numeric-columns/

Hope this helps..

If I have answered your question, please mark your post as Solved.
If you like my response or got a direction forward to proceed, please give it a Thumbs Up at least. Appreciate your Kudos. You can accept more than one post as a solution.

If you were still facing any issue or challenge, please do let me know so that I can try to check for you. Happy to help you further.

Blog: https://ecellorscrm.com

Cheers,
PMDY

Was this reply helpful? Yes No
stevenpetersmi 207 on at

Like (0)

Report

Hi

I have follow your step but none of what I want

It won't let me hide the end of two decimal places .00 into hidden format rather than decimal place to Zero

Was this reply helpful? Yes No
Verified answer

Devvj 1,132 Super User 2024 Season 1 on at

Like (2)

Report

Hi @stevenpetersmi
There are a couple of places in which you can change the decimal precision and some overwrites the others.
But one thing that works here atleast is to go in to the currency settings and change the precision on each individual currency there, have you tried that?

Hope that helps!

Was this reply helpful? Yes No
stevenpetersmi 207 on at

Like (0)

Report

Thanks for the reply. Personally, I think it is bad practice for the MS system because they force it all into the environment. After all, one app requests Decimal and another App needs to hide Decimal.

The same goes for removing the comma, as they should allow us to remove a column table/App or the whole environment.

Was this reply helpful? Yes No