Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to show quantity in my listboxes without any decimals.
What expression can I use since I can't manually change the number format in listboxes??
check your 3rd listbox in the attached file
use
round(field name) or num(fieldname,'#,###') in listbox expression
Hi Chris,
You can change the formatting of the ListBox but the underlying values still hold decimal places.
However, if wanted to exclude the decimal places then you can use Ceil() or Floor() functions as Expression in the ListBox.
Cheers - DV
Sivaraj-
using round() worked for some, but it changed many to Null values
DV-
using ceil() and Floor()
did the same thing as round, and changed many to null values
Is there not an expression like the following for formatting money values??
Money(sum(Sales), 'R#,##0', '.' , ',' )
Hi Leni
thanks, but also not working out.
showing null values and changed the number format to:
220,##0
Hi,
Just try this
=num(Money(FileName),'#,##0')
Chris - Please can you post the sample QV file or some sample data?
Thanks - DV
for
ceil()
floor()
round()
=Num(Quantity,'##0')
it only shows values to the hundreds and anything greater is marked as Null
any ideas??
check your 3rd listbox in the attached file
Hi,
In your 3rd listbox -> 2nd expr -> give "=sum(quantity)" instead of "sum(quantity)".
When I gave "=" sign in front of tat expr, it didnt show the decimal value
Just give a try