I would like to create a Yes/No calculated field where it determines when stacking location contains “-FLAT” and the average package count is less than 250, it would be marked as “Yes”, else “No”.
I created a calculated field with the following formula: ifelse(contains({stacking_location}, ‘-FLAT’) AND avgOver({pkg_count}, [{sort_center}, {parent_stacking_filter},{stacking_location}]) < 250, ‘Y’, ‘N’)
However, I am getting an error that says “Mismatched aggregation. Custom aggregations can’t contain both aggregated and nonaggregated fields, in any combination.”
I was wondering if anyone happened to know how I can get it to work. Thank you!
I gave your two calculated fields a try, but I am still getting the same error of "mismatched aggregation. Custom aggregations can’t contain both aggregated and non-aggregated fields, in any combination.