Overall goal is to show a count for records with an open status. FM Pro 12 Adv
I came up with two methods to accomplish the above. Wondering if one is better than the other and why.
Two tables: Portfolio and SR
Layout: records from Portfolio
Filtered portal, related records from SR
Filter: LeftWords ( SR::SR_Status ; 1 ) ≠ "Closed"
One field in portal: Count_SR
Summary: Count of SR Number
Create two fields in the SR table
Calculation; Unstored: If ( LeftWords ( SR_Status ; 1 ) ≠ "Closed" ; 1 ; 0 )
Summary: Total of CurrentlyOpen
CurrentlyOpenSummary is displayed on layout.
Is there a better way to accomplish the same thing? Are there any problems with using either of the above options?