Can you share a sample excel file if that's possible ?
I think your formula should be something like this:
IF ([Category]='Practice Building' AND [Category Weightage]>30)
Or ([Category]='Self Development' AND [Category Weightage]>30)
Or ([Category]='Thought Leadership' AND [Category Weightage]>40) THEN "eligible"
else "Not Eligible"
Eligability.twbx 1.1 MB
I have attached the excel sheet please check.
Practice Building Self Development Thought Leadership
above 3 fields comes under category and each have 30 - 30 - 40 Percent weightage.
I need to compare 3 fields and if it qualifies the criteria then it is eligible else not eligible.
Sample for Credit Points.xlsx 11.0 KB
Thanks for your response.
I tried using above condition but still not able to get the solution.
Its showing eligible for only few values. If all 3 meet the condition its not showing eligible.
I don't know where m i going wrong:(
I have given not eligible still its showing practice building value.
Can you attach your workbook Rini?
I think the problem is caused by the data structure not being suitable for this formula.
You need to attach a packaged workbook, so I can use the data
This turned out to be a lot more complicated than I thought it would be!
To summarise what I have done:
- For each Category I made a check calculation (this wasn't entirely necessary but it was easier to see the results). The check calculation uses a nested LOD to return the the Weighted Score for each employee/category:
- Then a final calculation to check the weighted scores:
And the final result:
I hope this has finally got the answer you were looking for!
Credit Point Dashboard.twbx 1.9 MB
Really really thank full to you,
I was not aware of this expression, i was even considering it simple.
But you made it.
Seriously Thank you.