Forum Discussion
Helper Vhelp on getting a complex index
Hi Islam ,
Sorry that it will be difficult to give you a formula that suits your requirement. I am not very clear about your actual needs and the logic behind it. Especially your model is so complex... I am not clear about the fourth step and subsequent steps you mentioned, what you want to achieve in the end? Could you please provide a simple example to illustrate your requirement at each step and the final desired result? IJust for example:
| Employee Name | encauragment decision date | assigning decision date | Vacation decision date | court punishment data | punishment decision date |
| aa | xx | xx | xx | xxx | xx |
| bb | xx | xx | xx | xxx | xx |
| cc | xx | xx | xx | xxx | xx |
Desired result:
if encauragment decision date is blank, then display assigning decision date; if xxx then xxx
| Employee Name | Index |
| aa | 1 |
| bb | 3 |
| cc | 2 |
Please note that it is not necessary to provide the detailed steps, just provide the sample data, calculation logic(conditions) and your expected result. We will consider what to do to get the result you want based on your expected result...
Best Regards
Helper Vto make things clear I'm aiming to create a report of updated employees who should get an encouragement add for current year after filtering out all employees whose don't meet current year encouragement add requirements