Skip to Content (Press Enter)
UserImage.jpg
Jens Vogelgesang
227Views
2Comments
Solved
Unable to convert to Javascript Number type because it will lead to precision loss
Question
Aggregate
OutSystems 11
  1. Retrieve Data and Group those
  2. Use aggregation function AVG
  3. Get an error message that the decimal number cannot be converted as it will lead to precision loss

Any idea to get this solved

0
0
09 Aug 2022
Copy Link
UserImage.jpg
Jens Vogelgesang
Solution

Yeap, you hint works.

I have added a new calculated column and use round(). Seems

See solution in context
0
0
09 Aug 2022
Copy Link
2018-05-15 08-41-11
Davide Periquito

Hey,


Strange error, have you tried to truncate that decimal to 15 decimals points? 


Not 100% sure, but you need to do a formatdecimal and then convert the text back to decimal. just give it a try

( TextToDecimal(FormatDecimal(,,,)) )

0
0
09 Aug 2022
Copy Link
UserImage.jpg
Jens Vogelgesang
Solution

Yeap, you hint works.

I have added a new calculated column and use round(). Seems

0
0
09 Aug 2022
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.