I need create a chart to show a Sales Rep's Incentive % based on Target Achieved %. This expression needs to be in the chart and not in the Load script.
Looking at the snippet you see the 2 tables that are not related.
REP 01 achieved 90% of Target, therefore I need to look at the Achieved_% field in the lookup table and display the Lookup value. In this case I should display 10%. In the attached App I have attempted a couple of expressions, but after meany hours, I need to escalate the request.
Hi. Thanks so much for still trying. Lookup() cannot be used in a expression in a chart.
Maybe by creating the Achieved % in the script I caused confusion. In the real world, the user can adjust a variable which impacts on the Achieved %. I have removed the Achieved % from the script and applied more logic to the "Lookup REP incentive" object. Looking at the expression you will see why I cannot do anything in the script.