Need Formula help

praba71
praba71
in Modeling

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

Tagged:

Answers

  • nathan_rudman
    nathan_rudman

    This is simply the rank formula

    with a grouping using a parent formatted line item

  • praba71
    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
    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

Categories