Status Tracer calculation

[Neffri]

Hi, 

I need to add Column 'Tracker' which will have 3 different statuses based on the 3 conditions:

• 0 = Never had an B (status for all months = 'A' or is blank)
• 1 = Has an B as of the month ( status for the month = 'B')
• 2 = Had an B (status in any month on the tracker = B)

Sample below: 

 I will be grateful for help 🙂

[atcodedog05]

Hi @Neffri 

It won't that way. Reason being A and B are single character. Where as exception and scope is not.

Suggestion would be after transpose use formula tool to change exception and scope to A and B then follow the process.