Jump to content

Problem Sorting by # in a portal


snatkins

This topic is 6947 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have a portal that has records shown in order of "edition #." From 1/25 (1 of 25) to 25/25. It is set to sort by the #: 1 first through 25. Unfortunately, when it sorts - it puts everything with a "1" first so it looks like this:

1

10

12

13

14

15

.....and then goes to 2, 21 - so obviously it is sorting by the first # - how do i fix this?

Help!

Thanks,

Sarah

Link to comment
Share on other sites

Is Edition # defined as text or number? If number, it should sort correctly. If text, you will need to sort by a calculation field equal to

Right( "0" & EditionNumber; 2 )

Link to comment
Share on other sites

This topic is 6947 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.