ok, I figured out the syntax some but my formula still isn't working. Any ideas what is wrong?
This is my formula for the unbound column. It still includes all of the category_ids in the unbound column. I want it to not include the ones below (10.2, 10.3, 10.5, 10.6, 10.8, 10.9)….
if(and( [Category_id] <> "10.2" , [Category_id] <> "10.3" , [Category_id] <> "10.5", [Category_id] <> "10.6", [Category_id] <> "10.8", [Category_id] <> "10.9" ), [Annual_Spent_After], 0 )