This content has been marked as final.
Show 2 replies

1. Re: Subtract using a subcategory (creating calculated field using subcategory)
Ivan Young May 27, 2016 1:52 PM (in response to Nellie Rajarova)1 of 1 people found this helpfulHi Nellie,
I'm still on 9.2 so I can't open your worksheet but if you want to get the sum of a+Bc you can use a formula like SUM(IF [Category] = 'C' THEN [Value] Else [Value] END). Let me know if you have any questions.
Good luck,
Ivan 
2. Re: Subtract using a subcategory (creating calculated field using subcategory)
Nellie Rajarova May 30, 2016 6:04 AM (in response to Ivan Young)2 of 2 people found this helpfulHi Ivan,
Thanks a lot. This really helped. I did as you mentioned
SUM(IF [Category] = 'C' THEN [Value] END)+
SUM(IF [Category] = 'A' THEN [Value] END)+
SUM(IF [Category] = 'B' THEN [Value] END)
and it worked like a charm.