3 Replies Latest reply: Jul 19, 2016 5:39 PM by Joe Kovach RSS

    How to create flag on summed up field

    Joe Kovach

      I have created fields to Flag whether or not there is an Error in a particular field, with 1's and 0's.  What I would like to be able to do, is create a Flag that says which fields have errors in them, that will then update as I filter on Policy's.  Here is an example of what my dataset looks like;


      PolicyField AField BField C



      I would like to be able to create a Flag so I could have a list box that would show;


      Fields with Errors

      Field A

      Field B


      Then if I select policy 1, it would function appropriately to only show Field B.


      My final dataset will have 2m+ Policies and 100+ Fields, so I'm looking for a good way of doing this.  The fields I'm comparing may build over time as well, so any way to automate it would be best, though I would take any solution at this point.