A small niggle but hopefully one that would be easy to fix for a future update.
It would be great to have an option for SVs to be rounded to just one decimal place. Currently the options are to either round to a whole number or to two decimal places, and sometimes neither are appropriate.
It would also be useful for the decimal place rounding to follow through to displays in one-click/Guardian screens. For example if saving P&L from a market then even if you set the SV to two decimal places it will still show £1.10 as 1.1 or £1.00 as 1. This makes it more difficult to scan through rows of data quickly.
Even better than the above would be an option to fix the number of decimal places within the formatting options for each individual custom column. Also ability to set individual font size would be amazing! Although I guess this would require a bigger update?
Suggestion - decimal place options
It is already an option but you would have to send the SV to a (Text stored value), see (value formatting) on the (Text stored value) page.
If the formatting = (As integer), this give you the £ and not the pence. Decimal place options are 1 to 6.
You can give the (Text stored value) the same name as the current Sv, so you wouldn’t have to change anything in your set up.
If the formatting = (As integer), this give you the £ and not the pence. Decimal place options are 1 to 6.
You can give the (Text stored value) the same name as the current Sv, so you wouldn’t have to change anything in your set up.
You do not have the required permissions to view the files attached to this post.
- jamesedwards
- Posts: 4938
- Joined: Wed Nov 21, 2018 6:16 pm
Interesting, thanks. Will have a play with this. That's the second time you've taught me things one can do with SV as text. Looks like I need to educate myself with all the options there.Dabbla wrote: ↑Thu Nov 27, 2025 5:25 pmIt is already an option but you would have to send the SV to a (Text stored value), see (value formatting) on the (Text stored value) page.
If the formatting = (As integer), this give you the £ and not the pence. Decimal place options are 1 to 6.
You can give the (Text stored value) the same name as the current Sv, so you wouldn’t have to change anything in your set up.
texttest.PNG
- jamesedwards
- Posts: 4938
- Joined: Wed Nov 21, 2018 6:16 pm
Thanks for this. Works a treat!Dabbla wrote: ↑Thu Nov 27, 2025 5:25 pmIt is already an option but you would have to send the SV to a (Text stored value), see (value formatting) on the (Text stored value) page.
If the formatting = (As integer), this give you the £ and not the pence. Decimal place options are 1 to 6.
You can give the (Text stored value) the same name as the current Sv, so you wouldn’t have to change anything in your set up.
texttest.PNG
The text SV format wouldn't work properly with my existing value formatting but I got around this using the number tagging method you showed me the other day.
eg store P&L as SV "Total_Profit", save text SV to two decimal places as "Total_Profit_Text" looking up SV "Total_Profit", and tagging with the value of SV "Total_Profit".
