Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
=if(match(Year,'2016'),sum({<LOB_ID ={705,706,709,713}>}DENOMINATOR),
if( match(Year,'2017'),sum({<LOB_ID ={713,714,715}>}DENOMINATOR)))
=if(match(Year,'2016'),sum({<LOB_ID ={705,706,709,713}>}DENOMINATOR),
if( match(Year,'2017'),sum({<LOB_ID ={713,714,715}>}DENOMINATOR)))
Of course, thank you!