Reducing number of found set

[salim]

Hi,

i want to sort my records based on "three(3) of the most active customers", note..(i can sort my data by the most active customers but then i want to be able to only have 3 records in my found set. How do i achieve this.?

[comment]

i can sort my data by the most active customers but then i want to be able to only have 3 records in my found set.

​Assuming you are scripting this, you can do:

...
Go to Record [ 4 ]  
Omit Multiple Records [ Get ( FoundCount ) - 3 ] 

 

Edited June 2, 2015 by comment

[salim]

​Assuming you are scripting this, you can do:

...
If [ Get ( FoundCount ) > 3 ]
 Go to Record [ 4 ]  
 Omit Multiple Records [ Get ( FoundCount ) + 3 ] 
End If

 

​Hurraaay! Thank you very Much, that breaks the ice...

[comment]

Oops! Sorry, I had a typo there: it should have been minus 3, not plus 3. And the If wrapper can be removed.

Edited June 2, 2015 by comment

[salim]

Oops! Sorry, I had a typo there: it should have been minus 3, not plus 3. And the If wrapper can Its

No problem, i took the underlying principle, so the typo didn't bother me, Again, thanks.