Solved

How to force Roman numeral ordering in SharePoint

Posted on 2010-11-18
10
1,194 Views
Last Modified: 2012-08-13
I need to group a set of files by their Policy Number, which is a text field containing Roman numerals.  I can't get it to put the IX group in its proper place; instead, it always shows up between the IVs and the Vs.  

I've ghost-numbered the files in Arabic numbers, but I can't display them that way, they have to be Roman.  

Any suggestions?  Thanks in advance for your help.
0
Comment
Question by:nsyyoung
  • 5
  • 4
10 Comments
 
LVL 16

Expert Comment

by:quihong
ID: 34166970
Use a calculated column that reads the roman numerals and converts them into regular numbers and sort order the list based on the calculated column.
0
 
LVL 8

Author Comment

by:nsyyoung
ID: 34167025
Is there a sharepoint-happy function for that?  I've only found the ROMAN function.
0
 
LVL 16

Expert Comment

by:quihong
ID: 34167218
Are we talking about the same thing?

I have no idea what a "sharepoint-happy" function is, but it sounds useful. :)

Where did you find a "ROMAN" function?

"Calculated Field" is the correct term I should have used.

http://msdn.microsoft.com/en-us/library/bb862071.aspx
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 8

Author Comment

by:nsyyoung
ID: 34167620
E.g., the Policy Section Number is a column of Number type.  Another calculated column has the formula =ROMAN([Policy Section Number] and displays a 5 as V.  In SharePoint, so it's "sharepoint-happy".

What would be function that I could use in a calculated field that would convert a roman numeral to arabic that sharepoint wouldn't choke on?

The main issue: I want the web part to group policies by policy numbers and show the groups in this order: V.a, VI.a, VII.a, VIII.a, IX.a, X.a.

It's maddening.
0
 
LVL 16

Expert Comment

by:quihong
ID: 34169726
Sorry I think I mis-understood your original issue.

Can you provide a few screenshots to illustrate how you got things setup and the issue?

I thought you were having difficulties with grouping and (primarily) sorting based on the roman numerals. But from the above example you start off with a '5' and use a function to convert it to 'V'. I still don't see any reference to a "ROMAN" function in the MS documentation on available calculated field function.

Not sure where the 'arabic' comes into play either.
0
 
LVL 8

Author Comment

by:nsyyoung
ID: 34169821
That's just an example of what works, but I want to go the other way.  The problem is that Roman numerals are really text, and in text ordering, IX does come between IV and V.  I DO want to group by the Roman numerals, but they're out of order.

Our 1,2,3 are Arabic, like I,II,III are Roman.

http://office.microsoft.com/en-us/windows-sharepoint-services-help/roman-function-HA001161058.aspx?redir=0
0
 
LVL 16

Expert Comment

by:quihong
ID: 34169888
So you can't group by the roman and sort by the number itself? Sorry, if I'm missing a important detail.
0
 
LVL 8

Author Comment

by:nsyyoung
ID: 34173506
I can sort by it, since the sort field can remain invisible on the page, just included in the view.  The group heading, though, is visible on the page.  Screenshot is attached.
queryscreenshot.jpg
0
 
LVL 17

Accepted Solution

by:
GreatGerm earned 500 total points
ID: 34174621
Unless I'm missing something, it seems this would be done easily with a DVWP and just have it sort by the ghosted Arabic number.  You could easily just output it as a table or list and format it as you desire.
0
 
LVL 8

Author Closing Comment

by:nsyyoung
ID: 34776895
I think this will work, it's just not as elegant as a CQWP display.  Thanks!
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

If you create your solutions on SharePoint sooner or later you will come upon a request to set  permissions of the item depending on some of the item's meta-data - the author, people assigned as approvers, divisions, categories etc. The most natu…
For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question