Using calculated columns in rollup columns

(1) Share

Report

Posted on by Robert Rybaric

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!

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Prakash4691 1,332 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Robert Rybaric 52 on at

Like (1)

Report

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.

Was this reply helpful? Yes No