Need Formula help

Highlighted
Contributor

Need Formula help

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

3 REPLIES 3
Highlighted
Community Boss

Re: Need Formula help

This is simply the rank formula

with a grouping using a parent formatted line item


Nathan Rudman, Anaplan Model Builder
Highlighted
Contributor

Re: Need Formula help

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

Highlighted
Community Boss

Re: Need Formula help

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

Nathan Rudman, Anaplan Model Builder