Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

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

Posted on by 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

  • Suggested answer
    GirishS Profile Picture
    GirishS 27,828 Super User on at
    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

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,459 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,783 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans