Sum Total and Average of SDP table Column data

Summary:

We have a SDP table data We need to fetch the average of one column named Rank as Average Rank = Sum Total of Ranks/ # of Ranks

for each Employee

Please advise

Content (please ensure you mask any confidential information):

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

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