Solved

Decimal Places

  • 29 March 2023
  • 3 replies
  • 199 views

Userlevel 3
Badge +7
  • Sidekick (Customer)
  • 21 replies

We have a situation where an item is billed in partial units, and credited back on another line. The value displayed on the request screen (for example) is $92.63 however the DB value is $93.635

A bit of an odd question:

 

Why is the value displayed to users not rounded up?

 

Is there a way to alter the number of decimal places displayed on the request screen?

 

Modify the DB value to match?

 

Modifying the DB 

 

 

icon

Best answer by Shneor Cheshin 4 April 2023, 01:28

View original

3 replies

Userlevel 6
Badge +26

Hey @ssabo 

Can you please specify the screen and the fields? A screenshot would be very useful as well.

Cheers!

Userlevel 3
Badge +7

Hey @ssabo 

Can you please specify the screen and the fields? A screenshot would be very useful as well.

Cheers!

line 2: 95.62 but maths = 95.625 

It sent 95.63 over to the o_m5 table. 

It’s office spacing me. 

Userlevel 6
Badge +26

Hey @ssabo 

I have tested this and could not get the desired result.

  1. I have updated the field in custom metadata to not have the ‘ROUND’ function and not limit the decimals
  2. I have updated in the UI designer to not limit the ‘Max Decimals’

These 2 actions did not resolve the issue.

My guestimate that it is hard coded.

Not sure what is o_m5 table, but you might be able to overide the value with a buisness rule. You will need to further test this.

 

FSM Metadata

UI Designer

Cheers!

Reply