Finance | Project Operations, Human Resources, ...

Enter a formula into a currency field to speed up data entry?

(0) Share

Report

Posted on by Andreas Hofmann Microsoft Employee

I would like to add simple formula into numerical fields on a form. Example: I would like to type 14 * 6.65 and have the form enter "93.1" (as in Excel if I would type =14*6.65). Can this be done?

Thanks

Andreas

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

nmaenpaa 101,166 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Andreas,

you should be able to achieve this by using Excel for data input.

UPDATE: Ah - almost forgot - if you enable the "New grid" feature, you can use formulas in numeric fields: https://docs.microsoft.com/en-us/dynamics365-release-plan/2020wave2/finance-operations/finance-operations-crossapp-capabilities/new-grid-control--general-availability

Was this reply helpful? Yes No
André Arnaud de Cal... 303,730 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Andreas,

Nikolaos provided the correct answer. With the new grid, the calculations are supported. The link he provided is broken; not sure why...

Here is another link with the details: docs.microsoft.com/.../grid-capabilities

You can enable the new grid control via the Feature Management workspace (tab 'Not enabled' or 'All').

Was this reply helpful? Yes No
Suggested answer

TracyXing Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Yeah, with new grid feature, you can realize this. Refer this docs.microsoft.com/.../grid-capabilities

Was this reply helpful? Yes No