Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have the following expression
sum({$<DefencePhaseSort = {$(#vPHASENO1)},TackleSplit={'Missed'}>} (PhaseTacklesPlayer))
I am calculation the number of tackles missed by a player in the 1st Phase
However, I have another dimension that is used to calculated the missed tackles for an individual player called TacklePlayerName. I use this dimension when looking at players individual stats
With the above expression I need to suppress Null Values from the TacklePlayerName Dimension
Any help will be greatly appreciated
Regards
May be this:
Sum({$<DefencePhaseSort = {$(#vPHASENO1)},TackleSplit={'Missed'}, TacklePlayerName = {'*'}>} PhaseTacklesPlayer)
Not sure I've understood completely, try maybe
=sum({$<DefencePhaseSort = {$(#vPHASENO1)},TackleSplit={'Missed'}, [TacklePlayerName] = {"*"} >} (PhaseTacklesPlayer))
or upload a small sample QVW to better understand your setting.
May be this:
Sum({$<DefencePhaseSort = {$(#vPHASENO1)},TackleSplit={'Missed'}, TacklePlayerName = {'*'}>} PhaseTacklesPlayer)