Unanswered

Power FX with Currency field not yet support & Calculated Behaviour discontinued

(0) Share

Report

Posted on by stevenpetersmi

207

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?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

pavanmanideep 495 Power Up Champ - 2025 on at

Like (2)

Report

Hi @stevenpetersmi

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

Was this reply helpful? Yes No
stevenpetersmi 207 on at

Like (0)

Report

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

Was this reply helpful? Yes No
pavanmanideep 495 Power Up Champ - 2025 on at

Like (2)

Report

Hi @stevenpetersmi

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

Was this reply helpful? Yes No
stevenpetersmi 207 on at

Like (0)

Report

I got it, thanks, apologies for it.

Was this reply helpful? Yes No