Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Workaround for Too Man...
Microsoft Dynamics CRM (Archived)

Workaround for Too Many Calculated Fields in Query

(0) ShareShare
ReportReport
Posted on by Barbara Forsman 602

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

  • Verified answer
    prt33k Profile Picture
    prt33k 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
    Barbara Forsman 602 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
    prt33k 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans