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 VI'm really feeling shamed for not being able to express my whole problem to you Mis but i'll try to give you the logic behind what my goal is specially that first solution you provided me is my promisive and seems like you got the whole problem
any way i made another post with more simplified data and in which i broke down the main goal to small problems making the whole algorith eventually