Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Deleting calculated fi...
Microsoft Dynamics CRM (Archived)

Deleting calculated fields not needed

(0) ShareShare
ReportReport
Posted on by DianeF1 210

We are cleaning up our application (long story) and we have quite a few calculated fields.  We are able to delete fields like spirit_totalvaluecosts but we are unable to delete spirit_totalvaluecosts_base.  When we try to delete the now not referenced field spirit_totalvaluecosts_base we get the error "This field contains a calculated money value and cannot be deleted. Select a different field and try again".

Is there any way to get these fields that are no longer in use out of the system?

Regards,
Diane

*This post is locked for comments

  • Suggested answer
    DianeF1 Profile Picture
    DianeF1 210 on at
    RE: Deleting calculated fields not needed

    Taking that second look and showing some one else did the trick.  I have several fields that are VERY CLOSE in name.  I did my delete on spirit_totalnrevaluemargindiscount with the next field being spirit_totalrevaluemargindiscount (the difference is total nre vs. total re).  When I looked closer - YES!!! the field with nre in it was gone and I'd mistakenly missed that.

    Thank you for making me double check :)

    Diane

  • Verified answer
    Georgy Profile Picture
    Georgy on at
    RE: Deleting calculated fields not needed

    I've faced similar issues (in D365 only!) with rollup fields. As I told before, what we did:

    1) publish all

    2) remove the fields from any solution apart from default.

    3) delete the field in default solution.

    as suggested above, try looking for dependencies.

    (I'm sure it's a stupid assumption, but could it have been that you acidentally "removed" the big brother field, rather than deleting it?)

  • DianeF1 Profile Picture
    DianeF1 210 on at
    RE: Deleting calculated fields not needed

    I deleted the main field and published.  The _Base field remained and when you try to delete the _Base field the error stating

    "This field contains a calculated money value and cannot be deleted. Select a different field and try again. " comes up. So now I have a _Base field that has no big brother field

  • Georgy Profile Picture
    Georgy on at
    RE: Deleting calculated fields not needed

    That's quite strange behavior. I would recommend you:

    1) Publish full solution.

    2) Try again.

    It's just a guess, assuming that you deleted the main field, the _base one should have deleted by itself.

  • Suggested answer
    TheMarkChristie Profile Picture
    TheMarkChristie 10,328 on at
    RE: Deleting calculated fields not needed

    Hi Diane

    I would open the field form the solution and check to see if there are any dependancies on it. If there are not i may suggest a workflow that clears the value of this field

  • Suggested answer
    Kristian Cole Profile Picture
    Kristian Cole 290 on at
    RE: Deleting calculated fields not needed

    1. Try removing it from the form first.

    2. Then  delete the field from the field section of your solution.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans