help with an expression

[#1]

Hi,

Please see attached. Need an expression which we can use on text boxes and charts.

We need the text box to count addressses but only in four neighbourhoods: Amblecote, Eccles & Weaste, Moss Vale and Clifton Green.

I was working on this but its not working:

=Count([Tenancy No]='Moss Vale')

We have a pilot running in these areas. Struggling with how this should be shown in the expression.

Chris

[its_anandrjs]

Hi,

For four neighbors try in text box with set analysis expression and hard code the four strings in the count expression.

=Count({<Neighbourhood={'Amblecote','Eccles & Weaste','Moss Vale','Clifton Green'}>} [Tenancy No])

Regards

Anand

[maxgro]

[#4]

Hi,

Thanks for your responses. Very helpful.

The last stage is trying to compre these four neighbourhoods against the others.

So we have this to select the four neighbourhoods:

Count({<Neighbourhood={'Amblecote','Eccles & Weaste','Moss Vale','Clifton Green'}>} [Tenancy No])

We also have the following the get an average which works.

Num(Avg(Tenancy_Length_Days),'#,###.##')

To get the detail we want, i.e average arrears in the four neighbourhoods can you suggest what the expression would be?

Chris

[MarcoWedel · Accepted solution]

Num(Avg({$<Neighbourhood={'Amblecote','Eccles & Weaste','Moss Vale','Clifton Green'}>} Tenancy_Length_Days),'#,###.##')

[#6]

Thanks so much

[MarcoWedel]

You're welcome

Regards

Marco