Have you tried:
IF [NewTotalMetroE MRC]+[Sdwan Mrc] >= [Net MetroE Quota] THEN 1
ELSEIF [NewTotal MRC] >= [All In MRC Quota] THEN 1
Thanks for your response. Yes, i did. i get RED squiggly line under the '>=' symbols. Error cannot mix agg and non-agg arguments with this function.
OK, I found the issue with the AGG and Non-AGG Functions.
IF sum([NewTotalMetroE MRC])+sum([Sdwan Mrc]) >= [Net MetroE Quota] THEN 1
ELSEIF sum([NewTotal MRC]) >= [All In MRC Quota] THEN 1