Generate report - In order of increasing numerical value

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


But if the other way round: