Create document library groupings based on calculated column

Hi,

 I saw the above query resolved in a very easy manner by my team mate which i though of adding here so that it can help some one else and is a common requirement.

So, the question is how we can create groupings based on calculated column in a document library where the grouping should be in in bunches of  '50'.

So the easiest solution for acheive the same is to create a calculated column, add the below formula, and to create a grouping based on the calculated field.

=INT(REPLACE(GROUPFIELD,1,2,"")/50,1)

*assuming the field name as GROUPFIELD  which is a single line of text

Forums Link : http://social.technet.microsoft.com/Forums/en-US/sharepointgeneral/thread/81e0df1b-1945-4fdb-a2b7-ab8d597df439