How to enforce a maximum of 100 of rating in a goal plan with MLT (metric lookup table) ?

[Hermine2]

Hi, 

We have configured a goal plan with MLT but I can't find out how to enforce a limitation of 100 for this rating. How to do so ? The code below is in the goal plan but doesn't block rating to 100.

<auto-population field="rating" mode="auto" calc-type="col">
<rule>
<calculated-result calculator-id="GM_MLT_BASED_RATING_CALCULATOR"/>
</rule>
</auto-population>

[SachinPachauri · Accepted solution]

@Hermine2 

You can try below code:

<field-definition id="metric-lookup-table" type="table" required="false" detail="false" viewdefault="on" showlabel="true" default-calc-type="interpolate" field-show-coaching-advisor="false" cascade-update="push-down">
<field-label>Performance Indicators</field-label>
<field-description>Performance Indicators</field-description>
<table-row-label>Performance Indicators</table-row-label>
<table-column id="rating" type="number" required="false" cascade-update="push-down">
<column-label lang="en_US">Rating (Value)</column-label>
<column-description>Rating Value</column-description>
</table-column>
<table-column id="description" type="text" required="false" cascade-update="push-down">
<column-label>Performance Target Description</column-label>
<column-description>Write Performance Target Description here</column-description>
</table-column>
<table-column id="achievement" type="number" required="false" cascade-update="push-down">
<column-label>Target Wieght</column-label>
<column-label lang="en_US">Maximum Points</column-label>
<column-description>Key Performance Indicator</column-description>
</table-column>
</field-definition>
<field-definition id="rating" type="number" required="false" detail="false" viewdefault="off" showlabel="true" display="number" field-show-coaching-advisor="false" cascade-update="push-down">
<field-label>Score</field-label>
<field-description>Score</field-description>
</field-definition>
<field-definition id="actual-achievement" type="number" required="false" detail="false" viewdefault="off" showlabel="true" field-show-coaching-advisor="false" cascade-update="push-down">
<field-label>Actual Performance</field-label>
<field-description>Actual Performance</field-description>
</field-definition>

<calculator id="actualAcheivement"><![CDATA[rating]]></calculator>
<calculator id="test1"><![CDATA[(weight*Rating)]]></calculator>
<auto-population field="rating" mode="auto" calc-type="col">
<rule>
<calculated-result calculator-id="test1"/>
</rule>
</auto-population>
<auto-population field="metric-lookup-table" mode="auto" calc-type="col">
<rule>
<rule-condition/>
<table-result>
<row>
<col id="achievement"><![CDATA[0]]></col>
<col id="description"><![CDATA[Achieved 0% to 0%]]></col>
<col id="rating"><![CDATA[0]]></col>
</row>
<row>
<col id="achievement"><![CDATA[100]]></col>
<col id="description"><![CDATA[Achieved 99.5% to 100%]]></col>
<col id="rating"><![CDATA[100]]></col>
</row>
</table-result>
</rule>
</auto-population>
<auto-population field="actual-achievement" mode="auto" calc-type="col">
<rule>
<calculated-result calculator-id="actualAcheivement"/>
</rule>
</auto-population>

[Hermine2 · Accepted solution]

Thanks a lot !!! Your reply guided me to find the right solution