AnsweredAssumed Answered

Is one method better than the other?

Question asked by PaulWebb on Oct 25, 2012
Latest reply on Oct 30, 2012 by PaulWebb

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.

 

Setup

Two tables: Portfolio and SR

Layout: records from Portfolio

 

Method 1

Filtered portal, related records from SR

Filter: LeftWords ( SR::SR_Status ; 1 ) ≠ "Closed"

One field in portal: Count_SR

Summary: Count of SR Number

 

Method 2

Create two fields in the SR table

CurrentlyOpen

Calculation; Unstored: If ( LeftWords ( SR_Status ; 1 ) ≠ "Closed" ; 1 ; 0 )

CurrentlyOpenSummary

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?

 

Thanks

Outcomes