Forum Discussion
Calculate value same column with condition
Hi all! I need to calculate the value of the state "in progress" for each ID by checking if the state column has "in progress" and "prioritized", otherwise I will not return anything. In this cas...
Thank you for the message, Anonymous.
RETURN IF((SEARCH("In Progress",_state,1,0) && SEARCH("Prioritized",_state,1,0)>0), _value,0)Best,
Paul
Anonymous Not able to see your formula
But in above code instead of both of the search output greater than two each search output should be greater than zero.
Thank you for the message, Anonymous.
RETURN IF((SEARCH("In Progress",_state,1,0) && SEARCH("Prioritized",_state,1,0)>0), _value,0)
Best,
Paul