Filed Calculation Issue
Hi, I have a field that I want to display a certain calculation, but because of my limited knowledge I can't figure out how to set it up. The field already displays an existing calculation, but necause of some changes being made, I need to modify it if possible. The current calculation simply counts the number of records with a field containing a specified value (the value is specified when the user slects an option from a pop-up menu:
What I need to do now is take that count, and then subtract the number of records where the field CME_Q contains the value "CME" in order to get the final number value to display in the field. Can anyone shed some light on how I might be able to do this?