text box script - show a %

[#1]

Hi,

Came across really cool expression that shows a headline figure in the form of a text box:

='£' & Num(Round(sum([Tenant_Arrears])), '#,##0') 

however, when trying to show another figure, this time a % were struggling. The script is below to try and get this % figure and works in princple in a straight table but we want this text box to just to show 'decent' properties as a % of all properties.

Current script : Num(Count ([Decency]= 'Decent')/ Count(TOTAL [Decency]), '#.##%')

Decency is the field with the 3 options of 'Decent', 'Non-decent' and Potentially Non-decent'

Figures used: 'Decent' = 4376,  'Non-decent' = 199 and Potentially Non-decent' = 10009

Appreciate any help.

Cheers

Chris

[#2]

hi

try this

Num(Count ([Decency]= 'Decent')/ Count(TOTAL [Decency]), '#.##0') & '%'

[tresesco]

Total keyword is used to ignore dimensions in charts. So in text box it has no relavance, you may try {1} like:

Num(Count ([Decency]= 'Decent')/ Count({1}[Decency]), '#.##%')

[Anonymous]

Try this

(Count ([Decency]= 'Decent')/ Count(TOTAL [Decency]))*100 & '%',

[#5 · Accepted solution]

Use set analysis:

=Num(Count ({<[Decency]= {Decent}>} [Decency])/ Count({1} [Decency]), '#,##0.00%')