How do divide a column of data ranging from 100 to 10,000 into Quartiles and Percentiles? I don't see a function for this or something called "TILES"

Thanks
Robb

This message has been edited. Last edited by: FP Mod Chuck,

I've never tried it but this might be helpful.

https://techsupport.informatio...cof/cof_tcn_073.html

An example of quartiles in code which creates the quartiles based on the DOLLARS field:

TABLE FILE ibisamp/ggsales
 PRINT SEQ_NO
      BY DOLLARS
      IN-GROUPS-OF 4 TILES
 END
 

App Studio Report Canvas supports this too:
Sort on the DOLLARS field, right-click it, and select Options....
In the pop-up window, select the Grouping tab and make your choices for the tiling you want.

I did not see any of these options in InfoAssist. I was able to get InfoAssist to produce quartiles by using hold files and computes. If you're interested, I can provide the code that InfoAssist generated for this.