AnsweredAssumed Answered

Filed Calculation Issue

Question asked by cmjones on Apr 30, 2009
Latest reply on Apr 30, 2009 by philmodjunk


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:


Count(Subject 1::Q_Rec_ID)


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?