You’re offline. This is a read only version of the page.
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
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.
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.
Hello,
I need some way using workflow or plugin, as I am not always using forms to enter data.
Regards,
Ashish
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
Thanks
Nilanka Sekhar Paul
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (