How do I sum up fields for work orders?

(0) Share

Report

Posted on by DevOs

Hello,

I have products in the CRM that have a field for each product called "Install times" which are fractions of hours (0.15 hours etc). When a work order is created, it gives a list of all the products used in that work order. But I would like another field on the work order form that gives me a sum of the "install times" for all those products that were used.

How do I go about this? I've spend a week trying to figure this out and for the life of my cannot.

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Abdul Wahab 12,119 Moderator on at

Like (0)

Report

RE: How do I sum up fields for work orders?

Hi DevOs,

How about calculated columns? Did you check the possibility of it?

Was this reply helpful? Yes No
DevOs 42 on at

Like (0)

Report

RE: How do I sum up fields for work orders?

How would I go about doing that? In dataverse or in the CRM?

Was this reply helpful? Yes No
Suggested answer

Abdul Wahab 12,119 Moderator on at

Like (0)

Report

RE: How do I sum up fields for work orders?

Hi DevOs,

Here you are: learn.microsoft.com/.../define-calculated-fields

Was this reply helpful? Yes No
DevOs 42 on at

Like (0)

Report

RE: How do I sum up fields for work orders?

I tried this, but it did not work. I end up with this:

But it does not make sense. I don't even know where I'm supposed to be doing this, the work order form? Products form?

Was this reply helpful? Yes No
Suggested answer

Abdul Wahab 12,119 Moderator on at

Like (0)

Report

RE: How do I sum up fields for work orders?

Hi DevOs,

I am interested in knowing the properties of all the columns; please share.

Was this reply helpful? Yes No
DevOs 42 on at

Like (0)

Report

RE: How do I sum up fields for work orders?

[quote user="Abdul Wahab"]
Hi DevOs,

I am interested in knowing the properties of all the columns; please share.
[/quote]

Was this reply helpful? Yes No