Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
A solution was kindly provided to us via the community which when selected just brough through a certain amount of properties meeting the following criteria:
This is on a serach string on a button entitled red properties. The criteria for red is any property with a value less than 4999:
concat({$ <[NPV Total]={"<-£4999"}>} Address, '"' & '|' & '"') & '"' & ')'
It worked to date but now with new data its showing one property as green when the button is selected. Please see attachment on what happens and then how its resolved - but we shouldnt have to additional bits to resolve.
Any help would be appreciated:
Chris
Flag would be much better & quicker & nicer, but with variables it can be like in attached app.
Hi Chris, I used this expression in 'RED NPV' button action:
= '(' & '"' & concat({$ <Address={"=Avg([NPV Total])<-4999"}>} Address, '"' & '|' & '"') & '"' & ')'
Thnak very much Karolina. Have both options now to use.
Much appreciated.
Chris
Would that work on different set of data?
Actually it's giving now 135 reds in stead of 136
True, that's because the address '3 Ciztxx Zfbkm' is in Moss Vale and Mountskip, so filtering only by address will lead to this kind of unexpected results, filters should apply to a key that combines neigbourhood and address to avoid this.
Maybe changing the action field from Address to UPRN and use this expression:
= | '(' & '"' & concat({$ <UPRN={"=Avg([NPV Total])<-4999"}>} UPRN, '"' & '|' & '"') & '"' & ')' |