Result of formatnumber() function is not correct

Beginner Questions
,
1

:bullseye: What is your goal?

Resolve the issue.

:thinking: What is the problem?

I used the formatnumber() function and one of the three results is inaccurate. I write the function “formatNumber (cost;1;.;,)”. Answer should be in 1 decimal place after decimal point but it’s showing 2 zero’s, what is the problem here?

:camera_with_flash: Screenshots: scenario setup, module configuration, errors

IMG_20260730_111817108.jpg
IMG_20260730_111817108.jpg4096×3072 5.97 MB

3

Hey Hadeed,

can you show a screenshot of the module output? I just tested it and can confirm it was only 1 sign after the decimal point.

4

Sure. I tried it two times, but both time shows same result.

IMG_20260730_115407851_HDR
IMG_20260730_115407851_HDR1920×1440 636 KB

5

Your sheet is formatted to show two decimal spaces. The issue is not coming from Make.

Also win key + shift + s opens the snipping tool which allows you to take screenshots. Then you can use ctrl + v to directly post them here.

6

Thank you very much for both the solution and the additional tip.