I have a hierarchy of items.
Each level of the hierarchy has a reference number,
which is a Text type column, so for instance 2.5.4.7 or 10.2.4.3
My problem is using these numbers to sort in a table view.
The sort will put a โ10โ before a โ2โ or a โ9โ, etc, so
1.5.20.4 10.8.8.4 2.4.21.3
instead of
1.5.20.4 2.4.21.3 10.8.8.4
I couldnโt find anything on this in the documentation or forum.
Does anyone know a way to achieve a โnumericโ sort on โtextโ numbers?
Thx
You could create a number type VC with formula NUMBER(CONCATENATE(SPLIT([ColName],"."))) and sort using that.
One way is NUMBER(INDEX(SPLIT([ColName],"."),1)) and then sort with that number. If you need to sort with the 2nd value as well, you can create another VC with the formula NUMBER(INDEX(SPLIT([ColName],"."),2)) and so on.
Thanks, guys.
Iโll have a look at both these ideas.
Specialized hierarchical views are whatโs really required. Please vote on it here:
I agree that built-in hierarchical functionality would be great, as my needs were pretty basic. In the end, I achieved the hierarchical functionality with table groupings, which seem to treat a textual โ10โ as greater than a textual โ9โ, which kind of solved my problem, but restricted me to displaying data and choices in a certain way. I also used INDEX(SPLIT(โฆ) to pull the numbers (still in textual format) from the hierarchical references (eg, โ4.Building Systems, 1.HVAC System, 3.Environmental Controlโ), so I could have purely textual numeric references (eg, โ4.1.3โ).
I too do Primavera P6 scheduling.
my contact info is on my website if you ever need anything. steadglobal.com
Thx, Grant. I donโt actually use Primavera, but I appreciate the offer.
I guess a lot of estimating / controls software probably uses the same numerical references huhโฆ
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |