News and Announcements icon

Dynamics 365 CommunityForums Customer experience | Sales, Customer Insights,... Currency Fields

Customer experience | Sales, Customer Insights,...

Suggested answer

Currency Fields

(1) Share

Report

Report

Posted on by CU02091413-0

8

How can I mix the Formula function on forms with Currency data type to get a currency field output.

The Formula Data type(Fx) output + A currency data type field/column in the calculated field to get a currency output.

I get the error even if my Total Selling Price in the calculated field is already a currency data type.

I also cannot use the formula data type(Fx) to get a currency field as the following error pops out, the alternative I do not get how to go about it, i.e Decimal(CurrencyField)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Muhammad.Affan 4,494 Super User 2025 Season 1 on at

Like (6)

Report

Currency Fields

Hi There,

Keep the data type of the field as 'currency' and the behavior as 'calculated'.

Thanks

Affan

If my suggested answer has helped, please mark it as verified.

Helpful resources

Quick Links

Subscribe to this forum!

Stay up to date on forum activity by subscribing.

Leaderboard

#1

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2

Martin Dráb 231,409 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans