Skip to main content
Question

Different decimal places returned for a field across the environments


Forum|alt.badge.img+8

Hello FSM experts,

 

I’m facing a problem where a certain field returns 10 decimal places when the table is queried in the Production environment where as the same field returns 0 decimal places across the other environments (TEST and DEV)

PROD:

TEST and DEV:

 

The custom metadata and the table script for this field is identical across the environments

 

seems like the mask type is ignored by the server in Prod.

Note: No decimal places are shown in the UI across all the environments.

 

Appriciate your help regarding this issue.

 

Kind regards,

Anupama Nagahawatta

2 replies

Shneor Cheshin
Superhero (Employee)
Forum|alt.badge.img+28
  • Superhero (Employee)
  • 1143 replies
  • November 20, 2023

Hi @AnupamaHN 

Besides the fact that SQL script returns an INT vs a DECIMAL.

What is the issue?

Cheers!


Forum|alt.badge.img+8
  • Author
  • Sidekick (Partner)
  • 27 replies
  • November 20, 2023

Hi @Shneor Cheshin 

Returning different values (with different decimal places) causes an issue with regard reporting. Because different results are returned in report data. So the value returned to this field should be consistent across the environments.

Kind regards,

Anupama Nagahawatta


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings