Please assist with my expression for the chart title,
=if(GetCurrentSelections(Country)=0 and GetCurrentSelections(BU)=0,'Evidence CA','Evidence CA'&'('&GetFieldSelections(BU)&')') .
So for example when I select BU='CIB' , the chart title is displayed as Evidence CA(CIB), but when I select for Country ='Kenya', the chart displays Evidence CA(). How can write the expression which will cater for either Country or BU?
So I expect when I select Country ='Kenya' in the listbox for example and my chart title displays Evidence CA(Kenya) and similarly if I select BU='CIB' in the listbox then my chart title displays Evidence CA (CIB). Same thing for the IR Charts