Need help on If condition

[abubakarsiddiq7]

Hi Experts ,

I have a requirement like :

Min 4Policies  in each month of Q1 ,'Gift1'

Q1 qualifiers achieving min 4Policies  in each month of Q2,'Gift2'

Q2 qualifiers achieving min 4Policies in each month of Q3,'Gift3'

Q3 qualifiers achieving min 4Policies Life in each month of Q4,'Gift4'

How to achieve this ?

[sidhiq91]

@abubakarsiddiq7 If you could provide some sample data then it would be better to help you with the logic.