0 Replies Latest reply on Apr 25, 2014 2:35 PM by Richard Hilton

    If statement with logic to measure results at higher level

    Richard Hilton

      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?