Good morning!
So not long ago I made a setup for a small deli shop that uses scale for most of their sales. However, they just realised that the reports round the quantity of sales. I tried to edit the report using the columns and format but it doesnt help.
Basically if they sell 0.3kg of a product, reports cut it out and round to 0 even though the price is still visible. Same goes for 0.51 but it gets rounded as 1.
I am not entirely sure whether there is an expression that fixes this behaviour or is it Windows regional settings that are messing it up.
This is what I tried with editting columns but no luck.
[Group Sales by Quantity:2, 1, 1]
{REPORT ORDER DETAILS:O.ItemGroup,O.Quantity.Percent.desc,O.Quantity.Sum:(ODI=True):{0}|{1}|[=F('{2}','#.##')]}
Total||{REPORT ORDER DETAILS:O.Quantity.Sum:(ODI=True)}