How to add computed table field?

Finance and Operations/AX Developer Forum
1

Hi All,

I have one parent table and child table. The child table has some columns date and price.

I have to display the average price based on the current date (one calendar month) in the form and look up.

calculation is: sum the price for the current month and divide the price by date count for this month

I thought if i add one computed table field then i can display that field in form and i also add that field in auto lookup field group.

Is there anybody have an idea about this issue?

Thanks,

Hari

2

You can either use a display method, save calculated values to a temporary table or build a computed column in a view.

Use a display method; it’s the easiest way.