You do not have permission to delete messages in this group
Copy link
Report message
Sign in to report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to
Hi
I have a value field, which contains the values 10000,3500,1500 & 500 for example. I need a query to format this value to display the results 10k, 3.5k, 1.5k and 0.5k
Can anyone help please?
Thank you
Ulrich Möller
unread,
Apr 30, 2020, 8:15:56 AM4/30/20
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Sign in to report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to
Am 30.04.2020 um 13:21 schrieb natura...@gmail.com:
> I have a value field, which contains the values 10000,3500,1500 & 500 for example. I need a query to format this value to display the results 10k, 3.5k, 1.5k and 0.5k
What about a calculated field: CStr([Value/1000) & " k"
Ulrich
natura...@gmail.com
unread,
Apr 30, 2020, 8:55:32 AM4/30/20
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Sign in to report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to
Thank you, a good start! But how do I round the result to 1 decimal place in the same formula?
Thanks again
Ulrich Möller
unread,
Apr 30, 2020, 1:16:08 PM4/30/20
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Sign in to report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to
Hi,
Am 30.04.2020 um 14:55 schrieb natura...@gmail.com:
> Thank you, a good start! But how do I round the result to 1 decimal place in the same formula?
>