You’re offline. This is a read only version of the page.
207
Hi
I am currently working on the data model field form and require two total amounts, "Total 1" and "Total 2", for the currency field.
I once attempted to add new columns, as they had suggested.
After reading the document, I decided to use the Formula. However, there is still an issue, but it is a new one.
Is there any way to bypass this issue or should I change the currency to plain numbers data?
I got it, thanks, apologies for it.
Check here https://learn.microsoft.com/en-us/power-apps/maker/data-platform/formula-columns?tabs=type-or-paste
This is recommendation from Microsoft to overcome the not supported behaviour for currency in calculated columns.
You can use like this Decimal(your field name) + Decimal(your field name2)
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
Thank you for your message. I understand it, but I'm afraid I can't see the big picture.
So, do I need to modify the column to fit an acceptable range? Etc. how it work
Direct use of currency columns and exchange rate in the formula is currently unsupported. The use of currency column is achieved through the Decimal function, such as Decimal(currency column) . The Decimal function makes sure the output is within the accepted range. If the currency column value exceeds the accepted range, then the formula returns null. So, use Decimal Function.
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
#1
mmbr1606
22
Super User 2025 Season 1
#2
stampcoin
19
#3
Michael E. Gernaey
15
Super User 2025 Season 1
Share
Report
All responses (
Answers (
