using lookup-table for calculations
I am making a Risk Register and want to relate a score 1-5 to a percentage.
I have made a seperate table_app, which users can change:
@risk_cat - @risk_perc:
1 - 7.5%
2 - 17.5%
3 - 27.5%
4 - 37.5%
5 - 50%
When a user makes a new risk in the Riskregister-app and gives it -say- chance "2", and cost-impact €1,000,000, I want to calculate 17.5%*1,000,000 = €175,000
Since the relation between the risk_cat and percentage is variable, I somehow need to use the table_app as a lookup-table. How do I do this?
Please sign in to leave a comment.