Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Calculated field for decimal point number type

(0) ShareShare
ReportReport
Posted on by 30

Hi

I created a calculated field and I want to set its condition for checking 2 fields with decimal point number type.

But I don't see them in the Field section because of their type.

Is there any way for me to do that without changing their type to something else?

Thanks a lot.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Calculated field for decimal point number type

    Hi Parinaz,

    Floating point numbers cannot be used in calculated fields, which is by-design.

    So you can try to use workflow or plugin to replace calculated field as I suggested above.

    And the address entity really doesn't recommend much customization, maybe you can create a custom address entity, which may make your operation more easier.

    Regards,

    Leah Ju

    Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

  • Parinaz_Ndlz Profile Picture
    Parinaz_Ndlz 30 on at
    RE: Calculated field for decimal point number type

    Thanks for the answer.

    actually, I want to create a calculated field that uses Latitude and Longitude fields (which are in Address Entity)

    to create a link.

    I want to set the condition as:

    If Latitude Contains data

    And Longitude Contains data

    then .....

    But I don't see them and I know that I shouldn't change Address Entity fields as much as possible.

    Regards.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Calculated field for decimal point number type

    Hi Parinaz,

    Floating point numbers cannot be used in calculated fields.

    And you don’t want to create new fields with other type to copy original value with flow or plugin.

    So you can directly build custom logic using plugin or workflow instead of calculated field.

    If possible, can you provide logic in calculated field to make me help you easier.

    Regards,

    Leah Ju

    Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans