Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)),''))