1 Reply Latest reply on Aug 20, 2009 6:38 AM by mrvodka

    how can i get the nummber of records with one condition in a calculation field?

    birders

      Title

      how can i get the nummber of records with one condition in a calculation field?

      Post

      i got a table with many Values, one of them is Opertaion serial.

      i want to get the nummber of Records, whose Operation serial is 23 , for example

       

      it is easy to do it with a script , but hwo to get the nummber in a calcultion field

       

      thanks

        • 1. Re: how can i get the nummber of records with one condition in a calculation field?
          mrvodka
            

          I cant see why you would want this is a calc but there are a few ways. I am not going to list them all.

           

          You can create a calc that returns the value 23. Then you can have a self join relationship from this field to the Opertaion serial field. Now you can just have a second calc use Count ( SelfJoin::Opertaion serial ).

           

           

          Another way may be to create a calc forumula of: Opertaion serial = 23. Then you can use a summary field of sum or calc to add up that field.