Calculated field is not appearing under Rollup Field

(0) Share

Report

Posted on by Community Member

Hi There,

I have a calculated field which is a whole no created in the child records and a rollup field again a whole no in the parent record. I wish the rollup field at the parent level to sum all the child records by taking the calculated field into consideration. However at the parent level when I try to edit the rollup field, to bring the calculated field from the child records to create a "sum" under aggregation, it is not showing up in the drop down?

What am I missing here? I'm sure this is not a product limitation because someone has already pulled this through earlier.

Cheers

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Suggested answer

Hugo Silva 1,374 on at

Like (0)

Report
Copy link

Link copied!

Hi Sunny make sure you follow the steps:

technet.microsoft.com/.../dn832162.aspx

Or

www.powerobjects.com/.../roll-up-fields-dynamics-crm-2015

Or

Tell us the steps or print screen how you done it.

Was this reply helpful? Yes No
Sayhaitokumar 7,042 on at

Like (1)

Report
Copy link

Link copied!

Hello Sunny,

A rollup can't reference a calculated field that uses another calculated field, even if all the fields of the other calculated field are on the current entity

You can access parental fields via the Lookup field to the parent entity, such as <LookupFieldName>.<FieldName>. This is not possible with multi-entity Lookup fields like Customer which can be Account or Contact. However, some entities have individual Lookup fields for a specific entity, such as ParentAccountid.<FieldName> or ParentContactid.<FieldName>

For more information read the below blog

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

Was this reply helpful? Yes No
Aileen Gusni 44,524 on at

Like (1)

Report
Copy link

Link copied!

Hi Sunny,

No you cant have nested calculated or rollup field.

This is the limitation.

"A rollup can't reference a calculated field that uses another calculated field, even if all the fields of the other calculated field are on the current entity."

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

Thanks

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report
Copy link

Link copied!

Hi Guys,

Appreciate the responses but what would you say for the solution mentioned in this blog.

inogic.com/.../calculated-fields-support-extended-for-datetime-data-types-in-dynamics-crm-2015-online-update1

Despite the fact I'm wondering how the rollup is referenced to a calculated field in the blog or is it that I'm missing something here.

Cheers

Sunny

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Sunny,

Did you figure this out? I'm having the same issue.

Regards,

Shashank

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi Gusni,

I have a relation 1:N i would like to do is a rollup field in parent entity to SUM values on calculated field at child entity, But calculated field does not appear .

Thanks

Was this reply helpful? Yes No