Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1245
  • Last Modified:

How to force Roman numeral ordering in SharePoint

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
nsyyoung
Asked:
nsyyoung
  • 5
  • 4
1 Solution
 
quihongCommented:
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
 
nsyyoungAuthor Commented:
Is there a sharepoint-happy function for that?  I've only found the ROMAN function.
0
 
quihongCommented:
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
nsyyoungAuthor Commented:
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
 
quihongCommented:
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
 
nsyyoungAuthor Commented:
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
 
quihongCommented:
So you can't group by the roman and sort by the number itself? Sorry, if I'm missing a important detail.
0
 
nsyyoungAuthor Commented:
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
 
GreatGermCommented:
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
 
nsyyoungAuthor Commented:
I think this will work, it's just not as elegant as a CQWP display.  Thanks!
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now