I have an IF statement to pick compare two value and take the higher one. However the comparison is being done at the lowers level and I want the comparison to happen at a higher level. That level being called Promo ID. So if Nielsen> Projected then Nielsen but I can this done at the Promo ID level. What is the syntax?