Page 1 of 1

Custom_SQL and Zero value

Posted: Mon Oct 25, 2021 7:43 am
by Sebastian
Hello,

my first post and I hope this is the right forum.

I have a simple profound page with a custom_sql in a grid with two columns. The sql statement select two values. First is char and second numeric (9,2).

All is shown correct exact für the numeric values < 1. Here it doesnt show the leading 0. Like 0,00 -> ,00

How can I change/transform/set this to bew displayed correct?

Thank you in advance
Sebastian

Re: Custom_SQL and Zero value

Posted: Mon Oct 25, 2021 2:54 pm
by Scott Klement
How are you formatting the output to control the leading zeros?

Are you formatting it within the SQL statement? Or are you using the "load into widgets" property and formatting it in the binding dialog? How would I create the same problem you're having?