It seems to be treating all columns as text and so reports 1190 before 970 say. I deally I would like to report on components in a way that allows the cut dimensions to increase in size as you move down rows.
I was hoping that it would be fairly straight forward to do but am struggling somewhat.
You would have to Group by “Cut_Length” rather than “Name” , you can make a special report for this
@Barry
However, because the sort “sees” the items as text, it will order them 1375, 1440, 550, 825
So I don’t think its possible at this stage,
as per my example
Do you have excel?
Since the report treats the values as text, and I’m assuming you’re calculating those values within a dynamic component, come up with a formula that adds leading zeros. You’ll have to make a guess as to the maximum value you expect to see to know how many zeroes to add in front of the actual value since you can’t take a “max” value across component instances.
I might make a stab at this once I’m more awake (and home from work) unless someone beats me to it.
That sounds like it could do the trick. Since it is a way to work it in excel. Thanks for the response, I will have a look into it now. If you do manage to have a spare 5 it would still be appreciated if you could have a bash at it. If I manage it first I will let it be know on here.
Still don’t have the time (yet) but I did get one inspiration:
Pad with spaces instead of zeroes! That way, your mind doesn’t have to “strip” the leading zeroes to grok the magnitude of the number. I think most, perhaps all, fonts have a single width for all numbers. If your display font has a space that shares the same width, then everything will line up - right justified!
I may be going way off track here. I can get the part name to work with the IF function to produce a zero at the beginning of the dimension when <1000. But I am struggling to create a C/C attribute where this function is performed to which then I can report and group by. Which should then order my dimensions logically right(?)
I am trying to use the concatenate function with the 'IF check attribute and the CCCheck attribute to combine the two values, but I am struggling. It is simply returning the CCCheck attribute. If I have the attribute text string the other way round (CCCheck first) then for some reason it works.
I am missing something obvious no doubt but would like advice on where I am going wrong
So, when I enter the formula I am still missing the leading zero when asking to be included. However if I ask it to include ‘m’ for example it will show…
I am not sure why it is eliminating the leading zero when it will include other characters.