Regarding decimal field values population
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-29-2025 05:49 AM
Hi ,
I would like to know when i give decimal values in one field and there is another dependency field which populated based on first field.
For example, if i give 12 as value in first field then second value field should be * 1000 like 12000.
But when i give 1.2 it should be 1200 right but getting as 12000
can anyone please help me how we can achieve this .
Thanks,
Sirisha
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-29-2025 05:55 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-29-2025 05:59 AM
Hi Venkatesh ,
Thanks!!
Here previously used Floating point number type for that and i was not able to change the type for that field .
Is there any approach i can follow to achieve this ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-29-2025 01:06 PM
Hi @Sirisha24
the only point is that if we use integer type or other type ServiceNow will not allow to show the outputs in decimals . We need to use correct data type to achieve these things.
Thanks and regards
Sai venkatesh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-29-2025 10:33 PM
Hi Venkatesh ,
The actual requirement is: when a value like 10 is entered in the "Number of Days" field, the "NFI Cost" field should correctly calculate the cost based on the defined conditions (e.g., 10 × 1000 = 10000). Similarly, if the input is 2.5, the cost should be calculated as 2.5 × 1000 = 2500. However, the current behavior is incorrect—when entering 2.5, it is being treated as 25, resulting in a cost of 25000. This issue needs to be fixed so that decimal values are handled properly.
Thanks,
Sirisha