Need Formula help

[praba71]

Hi 

Please refer the screen shot attached. Within a parent,I want to sequence the column 'Structure Type' based on each unique Job Name.For example, for Job Name 318317,I have marked 1 and 2 for 317542. 

Need to know how to setup the formula for the column 'Structure Type' for this requirement.

Thanks

Regards

Prabakaran

[nathan_rudman]

This is simply the rank formula

with a grouping using a parent formatted line item

[praba71]

Thanks @nathan_rudman for the response..

I am using the below formula for the column 'Structure Type.

RANK(JOB_NAME, DESCENDING, MINIMUM,JOB_NAME>0, PARENT(ITEM(ASSEMBLY_CONFIG))).

But I am getting the attached error. Can you please throw some light on this error and how to fix?

Thanks

Regards

Prabakaran

[nathan_rudman]

assembly config is your list where you are writing this formula ?
in your list you should have a property that's the parent of the list itself and that's your grouping.
Else you can use Assembly_Item

ps:try not to do formulas inside rank, it's bad for performance
ps2: our best practices say these formulas should be done in a module: gives you more flexibility