Checking calculation

[Neffri]

Hi all,

I'd be grateful if you can help or give me a hint how I can determine Status Tracker using Alteryx.

Example below:

Thank you!

[AlanSchaeffer]

Hi,
can you please explain a bit more the difference between 1 and 2, I think I don't see the trick here.

Thanks,
Alan

[echuong1]

You can essentially look for either the value "exempt" or "exemption" and create flags. From there, you can do a unique and then a sum of the flags.

[Neffri]

When there is no other value than exempt or exception then we should have status 1. 
If the value was "In Scope" or Null then the Status should be 2.

[Neffri]

@echuong1 your solution almost work , except the situation with NULLs

[echuong1 · Accepted solution]

See attached. You just need to add another condition for nulls.

If this solves your issue, please mark this as complete.

[Neffri]

I added this condition 🙂

Your solution was very clever, thank you very much 🙂