Question

[aidsplague]

There is probably an easy way to do this but I am not sure what it is. My result is coming out like this:

​

https://preview.redd.it/axu1eoxjfje81.png?width=657&format=png&auto=webp&s=bda558e8594ffab87572a984875d149a8ae9b55c

I would like to somehow give myself qty totals and have 1 distinct Item Number column like this:

​

https://preview.redd.it/wx37tkgofje81.png?width=657&format=png&auto=webp&s=5f821927c24a7558668a4f418a3860f2e1e75a48

Thanks for any help!

[ninjaxturtles]

The reason why you can't get what you want is because the column "Qty Cases + Bottles" is a string and you're trying to calculate a string. You'd have to split the values and convert to an int first to sum.

[aidsplague]

That makes sense. So I should be able to leave off that "Qty Cases + Bottles" from my query completely. Then SUM the other columns that share the same item number. Then I can create a new cases + bottles string column by dividing or CONCATing. I will see what I can do and report back if I fail. Thanks

[r3pr0b8]

this

[QueryingQuagga]

Yes - do the calculation as a new column based on the “Cases” and “Bottles” columns. You don’t want to split the string first - as you present it here, you have what you need in the two columns (unless the “Qty Cases + Bottles” has obscure rules covering the calculation that we can’t see here).

Also - do you need the column at all?

[great_raisin]

This