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

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) / How to make sum of two...
Microsoft Dynamics CRM (Archived)

How to make sum of two different type of field while using calculated field?

(0) ShareShare
ReportReport
Posted on by Ashish Moradiya 515

Hello,

I have two fields, one with Decimal number type and another with Floating point number type, I want to create a calculated field that will have sum of first and second field. Firstly when I tried to create calculated field by choosing floating point number as field type, it didn't allowed me to create calculated field, secondly while I select decimal number, it shown only Decimal type fields in formula section. So what is proper way to do so?

Regards,

Ashish

*This post is locked for comments

I have the same question (0)
  • Verified answer
    NILANKA SEKHAR PAUL Profile Picture
    NILANKA SEKHAR PAUL 340 on at

    Hi Ashish,

    If your requirement is to sum the two field value and show result on a third field then you can try with below link

    https://community.dynamics.com/crm/b/edwardsdnadynamicscrm/archive/2013/06/04/javascript-calculate-two-fields

    Thanks 

    Nilanka Sekhar Paul

  • Ashish Moradiya Profile Picture
    Ashish Moradiya 515 on at

    Hello,

    I need some way using workflow or plugin, as I am not always using forms to enter data.

    Regards,

    Ashish

  • Verified answer
    Nithya Gopinath Profile Picture
    Nithya Gopinath 17,078 on at

    Hi Ashish,

    Floating Point cannot be used with calculated fields, so that would mean that if you need a calculated numerical field that is not a whole number, you need to use decimal.

  • Verified answer
    Indika Abayarathne Profile Picture
    Indika Abayarathne 671 on at

    1) You cannot have any calculated fields for flaoting point values.

    2) It allows only one type to be in your formula.

    Try to use JS or any plugin acheive it. You can trigger the plugin at the time of saving the record.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
JS-09031509-0 Profile Picture

JS-09031509-0 3

#2
AS-17030037-0 Profile Picture

AS-17030037-0 2

#2
Mark Eckert Profile Picture

Mark Eckert 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans