In your calculation, if you use both aggregate and non aggregate fields, then tableau brings such error. Solution will be to use ATTR (Non Aggregate Dimension) for non aggregate fields then it should take care of your problem. Also, i encourage you to read some info about it at: Resolving "Cannot mix aggregate and non-aggregate arguments" Calculation Error | Tableau Software
Hope it helps
Yes typically you can just wrap [Sales Crates] to become ATTR([Sales Crates])
I honestly didn't think about that. Thanks Ivan!