AnsweredAssumed Answered

SORT BASED ON CALCULATION

Question asked by BrettGoodkin on Feb 25, 2012
Latest reply on Feb 27, 2012 by philmodjunk

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!

 

Outcomes