Power Apps

Currency field precision - set stored precision different from formatted decimal place

(1) Share

Report

Posted on by steeevid

323 Super User 2024 Season 1

Hi guys,

Have a very very annoying issues:

I use custom model driven app to generate sales related pricing.

Customer has an excel spreadsheet to double check the price. Customer is not IT professionals so their excel spreadsheet does not round currency calculation, it will store currency up to the maximum decimal place allowed inside Excel.

Model driven app on dataverse has a set currency precision decimal place, however this is VERY VERY limited:

If i set precision place to 2, after all the business process calculation happens in my model driven app, the total price that we present to the customer has a large difference => up to 2.0, this starting to get significant

If i set precision place to 4, this will significant improve the calculation accuracy, however every single field and grid in my model driven app will become un-readable: too many digits it's very user unfriendly!

I cannot simply find a solution that allow me to define different currency decimal places for STORED value and DISPLAYED value, any how can this be achieved?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (0)

RyanAutomates 139 on at

Like (0)

Report

Hi there,

Could you provide more information on how you're actually bringing the data into Dataverse? Is it a manual upload? Are you trying to bring it in using Power Automate? Are there any data transformations occurring?

Have you checked that the maths being performed is correct and what you'd expect to see at each stage of the calculations?

Was this reply helpful? Yes No
steeevid 323 Super User 2024 Season 1 on at

Like (0)

Report

Hi Ryan,

I input the field using my manual input on the form / Javascript / Power Automate.

This is not an import process, its a day to day usage scenario. I put in 1.7777 into the field, it became 1.78, that's fine, but i still need it to store 1.7777 behind the scene!

Was this reply helpful? Yes No
Suggested answer

RyanAutomates 139 on at

Like (0)

Report

Hi Steve,

Ah I see.

I've actually run into this problem before. I don't think we ever found the root cause of the problem, something Microsoft-y. The way that we got around it in the end was to do all the calculations with the precise values in JavaScript (or Azure Function for more complex scenarios) and fill in the earliest field in the calculation chain that would provide the correct answers with fields using precision 2.

Sometimes, we used hidden fields to do precise "ugly" calculations in the background and then put a field visible to show the "pretty" answer.

I wonder if you can do this using the new PowerFx calculated fields using the exact values and then display the pretty values in one go....

Hope this helps! :)

Was this reply helpful? Yes No
steeevid 323 Super User 2024 Season 1 on at

Like (1)

Report

I really dont understand why microsoft deleted the old forum, this forum is as dead as it can be and very f ing hard to use.

Was this reply helpful? Yes No