I’ve already calculated the container fill rate for each container. Now, I want to count how many containers have a fill rate < 50%. Here’s the formula I tried:
countIf({container_id},{tote fill rate}<0.5)
However, this gives me a “nesting of aggregate functions” error.
Is there a workaround to count the number of containers with a fill rate less than 50%? I’ve tried all the methods I know but haven’t had success so far. Any help would be appreciated!
You can’t use sum inside count (that’s what that error message means) but you can use sumOver instead. Can you try this calculated field for the fill rate instead?
