Do calculation from Select Value

asked 2016-10-17 01:50:51 -0600

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Hi, I want to calculate a project Cost. At the first Column I have kept, Name. I want to select a name form a list. Once I select a Name, his/her per hour cost will be visible in next Column [2nd column]. At the 3rd column I will enter the total hour required for the selected name. Then, at the Final Column, I want to see the total cost.

So, if I select Name, "john", and john's per hour rate is $100 and I want John will work in this project for 10 hours, his total cost is $1000. The main issue I am facing is, I can not make the Drop down list and assign per hour value for each name. So that, by selecting a name form the list, I get his / her per hour rate. Could you please help.

edit retag flag offensive close merge delete