Display cumulative average value of a column in worksheet based on data entered by manager — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Display cumulative average value of a column in worksheet based on data entered by manager

Summary:

Manager enters a bonus percentage for his/her reportees in the compensation worksheet. Say, manager has 10 reportees and for each of them manager enters 5 as bonus % in the bonus% column. So, the calculation is as below

Summation of bonus % given to all reportees = 5 +5……5 = 50

Average value = Summation / total number of reportees = 50/10 = 5

Can this value be calculated and displayed in the worksheet after when manager has entered bonus % value and saved the worksheet?

Content (please ensure you mask any confidential information):


Version (include the version you are using, if applicable):

25A


Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!