AnsweredAssumed Answered

Ranking?

Question asked by BeachedWhale on Dec 25, 2012
Latest reply on Jan 25, 2013 by philmodjunk

Title

Ranking?

Post

     I have a sorted found set. Now I want to rank this set from 1 to last.

     I looked it up and came across this website for identifying unique records and then ranking entries in a subsummary report, here is the link:

     http://www.filemakerhacks.com/?paged=11

     So in order to rank in their method, you have to create a field called flag_unique whose unstored calculation looks like this:

     (I'm trying to rank the Product Types)

      

Let ( x = GetNthRecord ( ProductType ; Get(RecordNumber) - 1 ) ;

If ( ProductType <> x ; 1 ; "" )

)   //   end let

     Here is the link: http://www.filemakerhacks.com/?p=25

     However instead of getting a 1 as flag_unique for the first instance of product type, I get a 1 in all instances. Is there something wrong with the field code?

Outcomes