Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Check the attached sample qvw.
Hi Jonathan,
Thanks for the reply! I tried this but it didn't work unfortunately.
Hi,
Many thanks for the reply and your example. Can you explain a bit further as I don't understand some parts.
You may have to add/remove "" or '' where appropriate