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.