Button select the client names who's sales is higher than 100

[#1]

Hi All,

I have a simple table with client names and sales.

Just want to create a button, if click, it selects those names with sales higher than 100.

Was trying to do this in "Action" but could be find a solution, could anyone help on this?

Thanks a lot.

[swuehl]

Use an action Select - Select in field

As field name enter your client name field, just the field name, no leading equal signs etc.

As search string, enter (exactely as written):

='=sum(sales)>100'

sales being your sales field.

[MK_QSL · Accepted solution]

Create a button object

Add Action

Field

Name

Search String

='('&CONCAT({<Name = {"=SUM(Sales)>=100"}>}Name,'|')&')'

[Anonymous]

see the screen shot ..check if that helps you

[#5]

That is really helpful, thanks a lot!

[MK_QSL]

I think swuehl's solution was much simple compare to my one.

[#7]

Hi Manish,

Another similar question, now I have a table with two fields. 1 is "Name" and the other one is "Sales" which have two values: YES and NO.

Still I am trying to create a button to select the clients who's  "Sales" is YES. in search string I was using the following:

='('&CONCAT({<Sales = {'YES'}>} Name,'|')&')'

However it does not work. Could you or anyone help on this?

Thanks

[#8]

Thanks a lot, however it seems I just could not make it work.

[MK_QSL]

This Should Work...

Field
Name

='('&CONCAT({<Sales= {'YES'}>}Name,'|')&')'