Skip to Content
0
Jun 11, 2020 at 01:55 PM

New to this trying to solve a if this then that sort of formula

59 Views

I am attempting to create a formula that will look at a data screen that has multiple rows of data but it is in sequence and the primary code wanted "21" will always be in sequence 1 or 2. After finding that I need it to narrow down whats left to a secondary code of "RBR" if in sequence 1 or 2 with a time stamp date of within the last week that was entered by a specific person. The problem that complicates this is that the "21" code is back dated to the date the court gives. Which is why the data clerk adds the RBR code which is the date entered. This report is going to run at the end of each week to give me all the 21 modified records. The other problem is I have no control how the data is entered so I can't specify that the 21 code be in line one and RBR in line 2. So they flip back and forth depending on the clerk that entered it. I also can just go off the RBR code and within the week as this code means a clerk went through the record so it's added to hundreds of records a day.

The way the rows and columns look are

Seq Act When Officer

1 21 MM/DD/YYYY Person

2 RBR MM/DD/YYYY Person

IE:

IF {caseact.seq} is [1, 2] and {caseact.act} startswith "2" then if {caseact.seq} is [1,2] and {caseact.act} startswith "RBR" and {caseact.when} in lastfullweek and {caseact.officer} like "person"

I'm still rather new to crystal so hopefully I can get help trying to figure this puzzle out :)