Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Hoping for some help. I rasied a question a while ago for help with a calculation. I was kindly provided with the following expression to calculate decency. It workes, in that it provided a figure and matches at an overall level; however, when I then click our neighbourhood filter it doesn't then match the detail:
Num(Count ({<[Decency]= {Decent}>} [Decency])/ Count({1} [Decency]), '#,##0.00%')
So to clarify when looking at figures overall the expression below matches the detail:
Overall
Decency Count %
Decent 4376 30.01%
Non decnt 199 1.36%
Potnetially Non Decent 10009 68.63%
However, when selecting a neighbourhood no longer works:
In Monton and Ellesmere we have the following breakdown; however, the expression above gives us a figure of 0.77%:
Decency Count %
Decent 112 18.54%
Non decnt 52 8.61%
Potnetially Non Decent 440 72.85%
...?
Hi Chris,
Count({1} [Decency] will give always the full count of decency.
If you want it to work with selection use Count(total [Decency] )
best regards
Chris
Hi Chris,
Count({1} [Decency] will give always the full count of decency.
If you want it to work with selection use Count(total [Decency] )
best regards
Chris