Jump to content

portal sorting


pmusaev
 Share

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

Recommended Posts

i have a portal sort going on, but it does not sort "Number" values properly, somehow i need it to sort on a number that is preceded by 0's... but not actually display the 0's.

this is how it sorts at the moment:

45,567,123

5,600

9,020,111

but i need it to sort this way:

00,005,600

09,020,111

45,567,123

and then format the numbers for output without the following 0's

5,600

9,020,111

45,567,123

Link to comment
Share on other sites

It sounds like you store the data in a text field. Change it to a number field and FMP will sort it numerically.

Alternatively, make a calculated number field based on the original field and use it to sort the portal.

Link to comment
Share on other sites

could you explain the alternative you provided in more detail please Vaughan...

"Alternatively, make a calculated number field based on the original field and use it to sort the portal."

i cannot change it to a Number field because there are other fields getting sorted that are text, as well as date. thank you for the quick reply!!!

cheers

Link to comment
Share on other sites

"i cannot change it to a Number field because there are other fields getting sorted that are text, as well as date"

That makes no difference. You can include date, time, text and number fields in a single sort and FMP will work them all out.

John's suggestion is a good one, though I might be tempted to add a heap more leading zeros in case the numbers get bigger.

Right("0000000000" & your_number_field, 10)

Link to comment
Share on other sites

This topic is 6593 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
 Share

×
×
  • Create New...

Important Information

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