Hi All,
I cannot figure out the following conditional function.
My situation:
I want to analyse for each entity in my dataset that the USERID of NEW_ENTITYSTATUS 200 is not the same as the USERID in NEW_ENTITYSTATUS 10 OR 15.
Problem is that it might be the case that sometimes NEW_ENTIYSTATUS status 10 and Sometimes NEW_ENTIYSTATUS 15 is not available, but one of them is for sure.
Function i tried:
IF ([ENTITY] = [ENTITY] AND [USER ID] AND [NEW_ENTITYSTATUS]="10" OR [NEW_ENTITYSTATUS]="15") = ([USER ID] AND [NEW_ENTITYSTATUS]='200')
THEN "Not desired" ELSE "Agreed"
ENDIF
This above function is not working correctly, i think because i combined AND statements + OR statements in my formula. But i have no idea how to write down the statement otherwise.
I did manage to create a single function that works:
IF ([ENTITY] = [ENTITY] AND [USER ID] AND [NEW_ENTITYSTATUS]='10' = [USER ID] AND [NEW_ENTITYSTATUS]='200') THEN ""Not desired" ELSE "Agreed"
ENDIF
In this case I am only able to check weather user ID = User ID for NEW_ENTITYSATUS 10 vs 200.
To make clear, in my example i want to conclude that for Entity 17 the output should be Desired.
Can someone please help me out?
