i'm tryin to count blank fields in a table but i found problems when i sort the table from a layout.
I have 3 tables:
- Users_Messages JoinTable
in the join table (Users_Messages) i have:
- CountMessages, Calculation, (Unstored, Get (FoundCount)
- CountNonReadMessages, Calculation, (Unstored, IsEmpty (Status)
- Total, Summary, =Total of CountNonReadMessages (Running)
I setup a layout based on Users_Messages JoinTable and OnLayoutEnter a script:
Set Error Capture
Perform Find (based on user Id)
$$nonreadmessages GetSummary ( Users_Messages::Total; Users_Messages::Date )
What I want is to use the value of $$nonreadmessages in another layout.
If I place the Total Field in a Leading Grand Summary and the count is right, but the value of $$nonreadmessages based on this field is not.
What could be the problem? Why the value of the global variable is different from the Total Field?