Here is my formula that is currently working!
(CASE
WHEN SKULabs Cost
>= 25 AND SKULabs Cost
<= 50 AND line_items_product_id
THEN '25-50 Bucket' ELSE 'not 25-50'
END
)
I'd like to add at 'Qty On Hand' > 1 in this formula but I'm unsure of where / or if there can be 2 "THEN" statements.
I'd like to be able to subtotal my Beast Modes, but they don't seem to subtotal when "subtotal is applied. So, I'd also like to add a subtotal in the Beast Mode as well, but again, I'm unsure of where to place it.
Thank you in advance your time and assistance!