Finance | Project Operations, Human Resources, ...

Create Computed field

(1) Share

Report

Posted on by Ghazi alshabatat

3201.Capture.PNG

Dear all,

How I can create a computed field in a data entity this field about summation from one field but the difference between these numbers exist in field (Type)

Example:-

Field Type
10 1
20 2
15 3

The computed field equal (1+ 2) -3

using D365 f&o

Thank You.

I have the same question (0)

All responses (7)

Answers (0)

huijij 19,811 on at

Like (1)

Report

Hi

What is the specific desired effect you want? Can you describe your requrement detailly?

Thanks.

regards

Was this reply helpful? Yes No
Ghazi alshabatat 35 on at

Like (1)

Report

This field is customization to show summation adjust the hour

Was this reply helpful? Yes No
Suggested answer

Rustem Galiamov 8,072 on at

Like (0)

Report

Hi!

Check this link Computed View Columns in AX 2012 (codecrib.com). The article is about AX2012 but it's applicable to D365FFO.

Keep in mind, that computed column - it's the SQL query result.

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 301,075 Super User 2025 Season 2 on at

Like (0)

Report

Hi Ghazi,

You can find information how you can add a virtual field in the documentation. Computed columns and virtual fields in data entities - Finance & Operations | Dynamics 365 | Microsoft Docs

Was this reply helpful? Yes No
huijij 19,811 on at

Like (1)

Report

Hi，

As far as I understand it, there is no way you can add calculated columns to the entity class in this scenario.

Unless you convert the calculation result rows to columns,

but such a calculation column cannot be bound to an entity class.

So do you want to add calculated columns or to add a total row at the end ?

regards

Was this reply helpful? Yes No
Ghazi alshabatat 35 on at

Like (0)

Report

Total row in the end

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

An entity is a collection of records. Not a collection of records plus additional fields (such as your total).

But you can create some kind of report with this data (e.g. an Excel report based on the data entity).

Was this reply helpful? Yes No