2 of 2 people found this helpful
you should change it to one of below
COUNT(IF [City] !='Columbus' THEN [Order ID] ELSE 0 END)
IF ATTR([City]) !='Columbus' THEN [No of Order] ELSE 0 END
You could likely achieve what you're after if you change your No of Order w/o Columbus City formula to
IF [City] !='Columbus' THEN 1 ELSE 0 END
Then aggregate how you wish on the sheet.
Thank you for the quick response! This is perfect