Skip to main content
Steve Molis (You Owe Me a Beer, Inc.) ๋‹˜์ด MVP Office Hours (US)์— ๊ธ€์„ ์˜ฌ๋ ธ์Šต๋‹ˆ๋‹ค

Here's my attempt at creating that Sample Report via a Formula field from today's #MVP Office Hours

 call.  

 

I created a plain vanilla Auto-Number field, that just assignes a number sequentially as they are creaed.  So it's not "true randomization", but close enough.  

 

Then I created a custom Formula(Number) field  

 

Field Name = Nth (or whatever you want)   

Datatype = Formula       

Result = Number( 0 decimals ) 

Formula = 

VALUE(RIGHT( Auto_Number__c , 1))

So now I can build a Report and add my Nth field to my report filter and say Nth equals 1, and the report will give me every 10th record created (10% sample size)

๋Œ“๊ธ€ 1๊ฐœ
  1. 1์›” 21์ผ ์˜คํ›„ 3:29

    PS.  You could also do 

    VALUE(RIGHT( Auto_Number__c , 2)) 

    If you needed to do a semi-random-ish 1% sample

0/9000