filter expression testing fine, but not working after save & verify

[Yobachus1]

So, lets say i have 2 tables

table1 has columns [uniqueid](key), [Date of Entry](date), [Action] (a yes/no enum), [site](enum text)

table 1 has multiple entries per date with variable entries for action and site.

table 2 has columns [computedkey], [Date of Entry](date & label), [Minor actions](number)

table 2 has 1 unique entry per date.

used a count filter expression in table 2 for minor actions (formula field) to get the number of columns in table 1 with the same date of entry that also have [action]="yes", & not([site]="option1").

Count(

              FILTER(
                             "Table1",
                             AND(
                                       [Date of Entry]= [_THISROW].[Date of Entry],
                                       [action]="Yes",
                                       not([Site]="option1")
                                       )
                            )

               )

I get nothing for every column, which is obviously not correct. 

I tried using the filter expression in a virtual column without the count and it tests as expected, and shows the reference rows in a nested table.

Even when i wrap it in a count it works great. 

but then when I press save and verify, the numbers disappear, and if i go back to test it, I get nothing. BUT the nested table still shows the related rows.

I get the same problem if I use a select expression in stead of filter, and I cant think of another way to do what im after, namely counting the number of rows in table 1 with the same date of entry in table 2 that also have specified values in 2 of table 1's columns. 

I've tried using a virtual column in a different table entirely just to test the expression on a specified date of entry, but its the same problem, works when I put the expression in and when testing, once I press save and verify, I get no rows on the test and zero on the count. 

anyone know what im doing wrong here!?

is something wrong with the expression , where im putting it, my table somehow, or my excel sheet!? 

[WillowMobileSys]

It is not always easy to understand how Test results are achieved in the Expression Assistant.  Make sure you understand how it works.

---

@Yobachus1 wrote:

anyone know what im doing wrong here!?

is something wrong with the expression , where im putting it, my table somehow, or my excel sheet!? 

---

We need to know where in your app you are using the expression and what you are trying to accomplish with it.

[Yobachus1]

okay. well, in table 2 one of the columns is [minor actions].

each entry in table 2 is a record of what happens on each day, so while the [date of entry] is unique, there is a [computed key] for each row. 

anyways, in the [minor actions] column of each row, rather than user input, i put the expression in the computed field (App Formula) to be automatically calculated.  The Objective being to keep an automatically updating record in table 2 of how many minor actions are logged for each day in table 1. 

but it computes as zero for each day. 

i mean the tables and the app are more complicated overall with alot more connections and child references and automation and such, but everything else, everywhere else is working as expected. This is the only thing i cant seem to make work, when it seems like it should and im not sure why. 

does this answer your query, or do you need more details!?!?!?