News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... how to get the summati...

Finance | Project Operations, Human Resources, ...

Suggested answer

how to get the summation of all the values of column.

(0) Share

Report

Report

Posted on by Devaraj g s

5

Hi Alll

I need help with this, I want to get summation of all the values of the row.

Example table

Emp Name	Emp Salary
****	20000
****	20000
****	30000

Expected result

Emp Name	Emp Salary
****	20000
****	20000
****	30000
Grand Total	70000

thanks

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

GirishS 27,823 Moderator on at

Like (0)

Report

RE: how to get the summation of all the values of column.

Hi Devaraj,

You can use aggregate function like sum to get the total value. Like below.

Select sum(EmpSalary) from tableName;

Also I guess you are using D365 FO. If that is the case you can right click the "Emp Salary" column and select "Total this column". This will add the total of the Emp salary column at the footer.

Thanks,

Girish S.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 293,097 Super User 2025 Season 1

#2

Martin Dráb 231,872 Most Valuable Professional

#3

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans