5 Replies Latest reply: Feb 27, 2015 9:59 AM by Jonathan Penuliar RSS

    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