Formula Help

[Raj_2]

Hi there, I am creating a work flow where I need a help on this piece.

There are 3 emp ids where based on one code BA & HP the coding will be decided, if it BA and HP then coding will be 22 . if it is only BA then it is 11.

Can you help me as per the attached pic. I am stuck here and my other work flows are ready which is linked to this.

[Thableaus · Accepted solution]

Hi @Raj_2 

Here's a way of solving this problem:

- Group by ID and concatenate all of your codes

- Use formula to Flag ID's with BA and HP

- Join the flag (22 or 11) to your dataset

- To leave the coding to the BA cell, you can apply another formula and just give null values to records that are not equal BA.

WF attached.

Cheers,

[DataKyle]

Does this work for you?

I summarized the codes into 1 field and used a formula tool to provide the Coding values.