expression help

[#1]

Hi,

Trying to create an expression in a a text box that will show number of properties that have a value of less than £5000.

Here is expression we currently have but its not working at all:

= Count([Address] [NPV Total] <=-'£5000.00')

Please can someone help?

Chris

[#2 · Accepted solution]

Count( {<[NPV Total]={"<5000"}>} [Address])

[sinanozdemir]

Hi Chris,

Try this:

Count({<[NPV Total] = {"<=£5000.00"}>}[Address] )

[#4]

Hi,

Can you help with the above. We want the same expression but to cover situation where its between 2 values: -£4999 - £4999.

I tried this but it doesn't work?:

=Count( {<[NPV Total]={>='-£4999.00' AND [NPV Total]<='£4999.00'}>} [Address])

Chris

[settu_periasamy]

Try this

=Count( {<[NPV Total]={>='-£4999.00'<='£4999.00'}>} [Address])

[#6]

Hi,

Unfortunately no..its says 'error in set modifier ad hoc element list.

Underline in red on }>} [Address]

Chris

[settu_periasamy]

May be try this

=Count({<[NPV Total]={">=-4999<=4999"}>} [Address])