Good day, I require help with the following: 1. For the 1st instance of A, if B > 0 then set C to 1 else set to 0. 2. For the next (2nd) instance of A, if B > 0 increase C by 1. 3. For the 3rd instance of A, if B to <= 0 reset C to 0 I am not comfortable writing code and prefer to use the query builder but do not know how to tackle this rule. I think that I should introduce X to count the number of times that A appears and create my rules based on that. eg. A X B C a 1 2 1 b 1 1 1 c 1 -2 0 a 2 3 2 c 2 4 1 a 3 0 0 (Assuming I have followed the correct logic as per my rules. Firstly, I do not know how to count how many times a variable appears in a column. Secondly, I do not know how to build this query. Your assistance will be greatly appreciated.
... View more