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
      1010
      2000
      3000
      4110
      501

      0

       

      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.

       

      Thanks,