Does anyone know where the error here might be? I'm trying to get a formula to stick for total quanitty of a SKU sold across total # of transactions
(sum{Quantity}/count{tranid})
l
Lee Hopper
01/04/2021, 11:19 PM
@Eric Shouler Do you have some more context to what you are trying to do? A saved search or something else? Maybe a screenshot?
e
Eric Shouler
01/05/2021, 3:48 AM
it was a saved search. While this logic didn't work, I actually wound up overlooking the average function of the field I needed, which worked.