Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
i need a frormula if an employee has only step ID "Plan+DO+Act"then give me as result succeed. see picture below
Solved! Go to Solution.
I would say create a numeric column, converting the text values of Step ID to numeric values. Then sum them together to determine which combination it is.
For example
6 + 2 + 8 = 16 = "Pending"
1 + 3 + 5 = 9 = "Initiated"
You just have to make sure that the combinations aren't intersecting, so i wouldn't use something so simple as 1-10!
We have in total 10. and every time it's another formula. so one formula is step ID 1,3 and 5. other formula is step ID 6,2,8
I would say create a numeric column, converting the text values of Step ID to numeric values. Then sum them together to determine which combination it is.
For example
6 + 2 + 8 = 16 = "Pending"
1 + 3 + 5 = 9 = "Initiated"
You just have to make sure that the combinations aren't intersecting, so i wouldn't use something so simple as 1-10!
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |