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.

Categories:

Other

Administration and Setup

Reporting and BI

Development / Customization / SDK

Field Services

Sales

All responses (6)

Answers (0)

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]
Suggested answer

Abdul Wahab 12,070 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.
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?
Suggested answer

Abdul Wahab 12,070 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
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?
Suggested answer

Abdul Wahab 12,070 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?