• Find every 20th Document Submitted

    Question: I need to create a list  with Documents that only end in a specific value.

    Business Problem: Client needs to sample every 20th Deal submitted to Docuware

    Configuration: I have a workflow that is triggered when a new deal is submitted. I am using an Assign Data activity to store the value of an arithematic expression that divides the DocID by 20 and stores the value to a decimal field. Then I am copying that value to a text field. 

    I am trying to use a list to return only the documents that end in .00 in the text field with the following where clause like '%'.00, but i am not getting any results.