Problems formatting numbers

Wappler General Bugs
#1

Thanks Teodor,
Can you guide me…currently it rounding it up in currency after conversion…e.g. $7.5 becomes $7…or $7.0

Thanks

Formatting Data in Dynamic Tables
#2

@Bankym,

Do you have the Precision set at 2?

precision
precision.PNG467×681 11.5 KB

#3

Yes…i accepted the default

#4

Thanks for the response,
Each time I set it successfully, it round up e.g. $5.3 to $5…do you mind sending me code portion of that part

Thanks

#5

You don’t really need code for this. All is done through the data formatter UI.
Please post some screenshot of what exactly:

  • did you select in the formatter
  • what’s the code generated for the expression
  • what value do you have, where is it coming from, how is it stored (what data type is it)
  • what is the result in your browser.

Your explanation is really unclear.

#6

I am inserting/updating a record. I followed the steps, convert to number>>then currency>>left the parameters as default. Each time I input 7.6 it round it up to 8. My form requires 7.6
Thanks

#7

Could be your field in your table. What type of field are you inserting it into?

1 Like
#8

Where does it round it? On the page? On insert?
I asked you to provide the exact description with screenshots in my last post.
I can’t really help you until you answer every question there and provide screenshots.

#9

Hello Teodor and etal, you guys are always on point. Thanks for your service. I figured it out, i had to change the data type from the dbase to decimal (10,2).
Best Regards

3 Likes
#10