Dual IF Statements

[byrnel0586]

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.

[m_woolf · Accepted solution]

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

     if( match(Year,'2017'),sum({<LOB_ID ={713,714,715}>}DENOMINATOR)))

[byrnel0586]

Of course, thank you!