O.Qty.Sum unnecessarily rounds values

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.

image

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)}

@ATechAsia Try this it should work for you:

[Group Sales by Quantity:2, 1, 1]
{REPORT ORDER DETAILS:O.ItemGroup,O.Quantity.Percent.desc,=[O.Quantity.Sum]:(ODI=True):{0}|{1}|{2}}
Total||{REPORT ORDER DETAILS:=[O.Quantity.Sum]:(ODI=True)}
1 Like

Works like a charm! Thanks @Jesse

image

Any idea what causes this?

Nothing causes it as its designed to work that way.

I am guessing thats why we have all those formatting options such as =F, =N and such.

1 Like

Yes it allows us to fine tune our reports and printer templates.

1 Like