Apps9 Lobby element - data source 4 decimal places but element only 2

Hello,

The data exactly in the tables are shown in the SQL data source . In the LOBBY element preview the decimal points should be taken from Regional settings (Tools→ Options→ Regional Settings → check the currency  format). This is considered for normal windows also. You may change the regional settings and check the change.

Thanks Dumeesha,

However our Regional Settings are set to six decimal places for all users. Do you have any other ideas?

Hi @sholmes,

Have you used the column type as Decimal? So here is my example.. 

 

You can get this..
 

But if you use decimal, it will be as follows.. That means in 2 decimal places like in your example.

If the data set is originally with 4 decimal places (according to the SQL data source image you have added), you may try number as the type. Then you will be able to get the values as expected.

Again..
Let me show you another tip..
This is for a situation like when we get different decimal places for each values as shown in Figure 2 and Figure 3, you can try the formatting to round the value for a given decimal place. In here, I gave it as 5..

So you can get the values very neatly..
 

I hope this helps.. 
 

Thank you for the above - it was set to number originally but I’ve changed it to decimal and I’ve had no changes. I don’t appear to have the same formatting options that you show in your screen shot, maybe because I’m Apps9? I’ve got round this issue by setting up a count box for each rate and displaying it on the lobby that way.

Thanks you @Minoshini Fonseka, just tried this to see if changing to text worked and it did. I’ll know for next request.