Microsoft Dynamics CRM (Archived)

Order of Calculation Field

(0) Share

Report

Posted on by Community Member

Hi All,

This is an issue I've faced in 2016 CRM. Below are the details -

Field 'C' = A + B

Field 'F' = C - (D * E)

All these fields are available are Entity 'Ey'.

On Save of a record,

1. Calculation doesn't take place. At least in same order.

2. Workflow making use of 'F' value is failing since 'F' found null.

Hopefully this provide sufficing info for resolution!

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Aiden Kaskela 19,696 on at

Like (1)

Report
Copy link

Link copied!

Hi Ankush,

I don't think there's a reliable order for calculated fields. You can avoid is by updating your conditions though:

Field 'C' = A + B

Field 'F' = (A + B) - (D * E)

That way they can both be evaluated independently from each other.

Hope this helps! I'd appreciate if you'd mark this as Answering your question.

Thanks,

Aiden

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Aiden,

Thanks for the response!

I actually had generalized the calculation for 'C'. It in reality has a conditional calculation.

Hence the field calculations are not being done as expected.

Was this reply helpful? Yes No
Suggested answer

tpeschat 4,930 on at

Like (0)

Report
Copy link

Link copied!

Hi.

According to my experience the calculation of calculated fields is only working reliably, if no null values are involved. As soon one of the involved fields is null, the calculation result is null.

so in my case I set all fields to 0 on foarm load, in case they are null. This helps, that the calculation is done properly.

Reg. workflow: In an article about rollup and calculated fields, I recently read, it was stated that calculate fields are only calculated on demand (when you are on the form). There value isn't stored in the database, which means the can not be used within a workflow.

hth Thomas

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi All,

I had missed a vital information.

Field 'C' = A + B

Field 'F' = if(C>G), C - (D * E): something else

Basically, I'm using a calculated field's value in another calculated field for condition.

Is this not possible? If not, any alternatives please!

Thanks in advance!

Was this reply helpful? Yes No
tpeschat 4,930 on at

Like (0)

Report
Copy link

Link copied!

According to the technet article about calculated fields you should be able to reference/use another calculated field in your calculations:

"A maximum number of chained calculated fields is 5"

ä.

.

.

.

.

.

.

So I would assume it should then also be possible to reference another calculated field in your if condition.

technet.microsoft.com/.../dn832103.aspx

But it' also stated that a calculated field, which depends on another calculated field can not be referenced in rollup fields.

Can be found in the considerations and limitations chapter.

br Thomas

Was this reply helpful? Yes No