Post

1 follower Follow
0
Avatar

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?

Wichard Hulsbergen

Please sign in to leave a comment.