2 Replies Latest reply: Jun 22, 2016 11:34 AM by Linda Pembroke RSS

    Dual IF Statements

    Linda Pembroke

      Hi,

      Can someone tell me what I've done wrong here? The calculations do not work for 2016 after I added the additional 'or' statement.

       

      =if(match(Year,'2016'),sum({<LOB_ID ={705,706,709,713}>}DENOMINATOR) or match(Year,'2017'),sum({<LOB_ID ={713,714,715}>}DENOMINATOR))

       

      Thanks.