Chart Title Expression

[zwyne]

Hi All,

PFA,

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?

Thanks

[agigliotti]

what does your expected result for Country = Kenya is ?

[zwyne]

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

[agigliotti]

maybe this:
='Evidence CA' & '('&GetFieldSelections(Country)&GetFieldSelections(BU)&')'

[sunny_talwar · Accepted solution]

Try this

=If(GetSelectedCount(Country) = 0,
	If(GetSelectedCount(BU) = 0, 'Evidence CA', 'Evidence CA('& GetFieldSelections(BU) &')'),
	If(GetSelectedCount(BU) = 0, 'Evidence CA('& GetFieldSelections(Country) &')'))

[zwyne]

Thank you very much  Sunny, always a life saver