Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Adding condition to the 'Select in Field' action button

Hi everyone,

I am trying to create a button named 'Rec failed' for datasets that do not reconcile (hence 'Difference' <>0). Ideally, when this button is clicked, I want it to show records where difference does not equal to 0. The field for this would be 'Difference' , I have tried a few things for Search String, but they didn't work. Your help would be greatly appreciated here!

and to complicate things, my aim is to get these buttons work on different levels :- e.g. selecting fields where difference <> 0 at a Group level, selecting fields where difference <> 0 at a Property level, and selecting fields where difference <> 0 at a account level.  (These levels are hierarchical where there are two groups, each group contains different number of property , and each property holds a number of accounts).

thanks a lot!

Michelle

5 Replies
jpenuliar
Partner - Specialist III
Partner - Specialist III

Hi Michelle,

Add an action : Select in Field ; Field: "Difference" ; Search String: "0"

add another Action: Select Excluded; Field: "Difference"

This will select all values except "0" in your "Difference" field

tresesco
MVP
MVP

Check the attached sample qvw.

Not applicable
Author

Hi Jonathan,

Thanks for the reply! I tried this but it didn't work unfortunately.

Not applicable
Author

Hi,

Many thanks for the reply and your example. Can you explain a bit further as I don't understand some parts.

jpenuliar
Partner - Specialist III
Partner - Specialist III

You may have to add/remove "" or '' where appropriate