web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Workaround for Too Many Calculated Fields in Query

(0) ShareShare
ReportReport
Posted on by 608

I have multiple calculated fields I am using on a form for our Quote entity.  I want these fields included in a printed quote template, but I get the message that there are Too Many Calculated Fields in Query when I try to add them to an excel template.

I thought I could work around the issue by creating another field and populating it with the value of the calculated field.  I've tried populating the new field with a business rule and a workflow, but neither works. 

My calculated fields are currency and my new field is also currency.  Is it possible to take the value from a calculated field and populate another field on the same form?  How would you do it?

Many thanks!

*This post is locked for comments

I have the same question (0)
  • Verified answer
    prt33k Profile Picture
    6,907 on at
    RE: Workaround for Too Many Calculated Fields in Query

    I believe you did this on workflow.

    Is this a synchronous workflow? also did you select the field in "record change field" properties ?

    I have done this with text field and it worked fine for me.

  • Barbara Forsman Profile Picture
    608 on at
    RE: Workaround for Too Many Calculated Fields in Query

    I do not get any error - it just doesn't update.  I tried

    If Selected Partner 1 = Yes, then update New Field with value of Calculated Field.

  • prt33k Profile Picture
    6,907 on at
    RE: Workaround for Too Many Calculated Fields in Query

    Hi Barbara,

    The reason for error is because Saved queries can have a maximum of 10 unique calculated fields.

    Please refer: technet.microsoft.com/.../dn832103.aspx

    However the workflow or plugin will allow you to update field with the calculated field value. Are you getting any error when setting the new field value to the calculated field?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
Christoph Pock Profile Picture

Christoph Pock 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans