cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Using calculated columns in rollup columns

Hi, not sure whether this is a bug or a feature, please confirm the correct answer:

1. Generally, it is possible to include calculated columns in the formula for rollup columns

2. This works fine, however, when part of the formula in the calculated column contains columns from RELATED tables, than suddenly this column is no more available to be used in a rollup formula.

 

Bug or feature?

 

Thanks!

 

1 ACCEPTED SOLUTION

Accepted Solutions
Prakash4691
Super User
Super User

Hi @Robert-Rybaric ,

You can use calculated column in roll up, if you use the fields only from the parent entity. If any related column used in calculated field and that calculated field will not be available to refer in any rollup fields.

 

If it answers your question. Kindly give kudo and accept it as solution.

 

Regards,

Prakash

View solution in original post

3 REPLIES 3
rampprakash
Super User
Super User

Hello @Robert-Rybaric 

 

Hope you are doing good.

 

1. yes it is possible

2. Its a Feature, because as it is referencing.

 

Lets wait for others comments too..

 

Please mark as Answer if it is helpful and provide Kudos


Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Prakash4691
Super User
Super User

Hi @Robert-Rybaric ,

You can use calculated column in roll up, if you use the fields only from the parent entity. If any related column used in calculated field and that calculated field will not be available to refer in any rollup fields.

 

If it answers your question. Kindly give kudo and accept it as solution.

 

Regards,

Prakash

Thanks, not happy with that, but it is how it is. I miss a logic in this, since a calculated field has a value, and that should be available regardless if the value is calculated just from own fields, or from fields from a relationship.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Users online (2,572)