3 Replies Latest reply on Feb 27, 2012 10:27 AM by philmodjunk

    SORT BASED ON CALCULATION

    BrettGoodkin

      Title

      SORT BASED ON CALCULATION

      Post

       I'm a new FM Pro Advanced 11 user, so I apologize in advance for my novice question!

       

      I have table with the following fields:

      CDC_NUM (TEXT)

      DATE

      TIME

      NOTES (TEXT)

       

      I need to create a calcuation that counts each occurance of a particular CDC_NUM.  In other words, in this table, there will be numerous records with the same CDC_NUM.  Then, I need to be able to sort in order of the number of occurance.  The end goal is display the most active CDC_NUMs.

       

      I've created Calculation and Summary fields that count the number of occurances; however, I'm unable to Sort or Find these fields in my layouts.

       

      Thanks in advance for your help!