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.
This is simply the rank formula
with a grouping using a parent formatted line item
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?