Value is not shown up

[peisenrot]

Hello 

I have a formular for a KPI 

if(GetSelectedCount(PursuitsName)='1' and GetSelectedCount(BU_Round)='0',
{<LastRoundYN={'Yes'}>}BU_Round,
if(GetSelectedCount(PursuitsName)='1',
aggr(max(BU_Round),PursuitsName),''))

it is showing the BU_Round when i have selected one PursuitsName but no BU_Round. When I additional select a BU_Round the Value of the BU_Round is not shown. 

I tried without aggr and without max but both didn't solve the problem. Any idea what I can check?

Best regards

Pia Eisenbach

[marcus_sommer]

You could try an outer aggregation for the aggr() like:

if(GetSelectedCount(PursuitsName)='1' and GetSelectedCount(BU_Round)='0',
{<LastRoundYN={'Yes'}>}BU_Round,
if(GetSelectedCount(PursuitsName)='1',
max(aggr(max(BU_Round),PursuitsName)),''))