Comparing values based on range and out put should be % value
Hello,
I need to achieve below logic. can someone help me what would be the right rules to use.
If emissions <50 kg CO₂e/€M → Score 90-100 (Low Emissions - Excellent)
If emissions 50-100 kg CO₂e/€M → Score 50-89 (Moderate - Needs Monitoring)
If emissions >100 kg CO₂e/€M → Score 0-49 (High Emissions - Poor Performance)
I have this 50kg as threshold value in the table, and how can I get the score value from range instead of constant value
***Edited by Moderator Marissa to add Capability tags***
To see attachments, please log in.
Posted: 3 weeks ago
Capgemini
Capgemini
IN
Hi @SowmyaLam,
As I can understand from your post, you want to get score from a range of emission in kg CO₂e/€M.
If so, please follow below steps :
- Make a Decision Table that returns the score based on above logic.
- In an activity loop over a range of emission value for which you want to have scored.
- Inside loop use decision table to get the score for current iteration and store for further use.
Hope it helps !
Thanks, Ankit