Total sum for calculated column with multiple formula

Question

Total sum for calculated column with multiple formula

Sermae C. Platino 20

Hi AllHow to enable sum in the calculated column with multiple formula. For clarification, the calculated column I'm pertaining to is the "ymd in number" boxed in red color.

The formula I used is =([To]-[From])/365 here's the screenshot of my dashboard. Would greatly appreciate simple guidance because I am not IT specialist. Thank you very much.

User's image

Yanli Jiang - MSFT 31,666 Reputation points Microsoft External Staff

2023-07-31T05:33:37.24+00:00

Hi, we are currently doing some research on this issue, will let you know as soon as possible.

Answer accepted by question author

1 additional answer

Your answer

Yanli Jiang - MSFT 31,666 Reputation points Microsoft External Staff

2023-07-31T05:33:37.24+00:00

Hi, we are currently doing some research on this issue, will let you know as soon as possible.

Answer 1

Hi @Sermae C. Platino ,

Sorry, I'm sure I misunderstood you earlier. According to your description, there is no way to achieve this in MS Lists. The field value of each column can only serve one item, and each field in the column is at the same level, which is by design. If you want to achieve summation, you can try to Export to Excel when the summation is required, and then perform the summation in the Excel file. Or try Power BI.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Yanli Jiang - MSFT 31,666 Microsoft External Staff

Hi @Sermae C. Platino ,

As the Q&A forum is an open platform, please pay attention to protecting your privacy information. When posting a question, cover or code your private information. Thanks.

According to your description, you can use the DATEIF function.

Below is my test:

the formula is :

=DATEDIF(From,To,"d")

07314

The result:

07315

More information about formulas, please refer to:

https://support.microsoft.com/en-us/office/examples-of-common-formulas-in-lists-d81f5f21-2b4e-45ce-b170-bf7ebf6988b3

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Sermae C. Platino 20 Reputation points

2023-08-01T01:46:17.7466667+00:00

Hi. I tried using the provided formula but the "sum" function is not showing..
Yanli Jiang - MSFT 31,666 Reputation points Microsoft External Staff

2023-08-01T05:50:20.8566667+00:00

Hi @Sermae C. Platino ,

Sorry, I may have misunderstood your question, can you describe the sum function you need? Or the effect you want to achieve. Let's work it out together. :-)
Sermae C. Platino 20 Reputation points

2023-08-01T06:31:38.1333333+00:00
Hi @Yanli Jiang - MSFT ,

I am actually exploring the Microsoft List for Employees Database. Primary information that I input in the database are

Column 1: Name of Employee

Column 2: Name of the Company

Column 3: From (starting date in dd/mm/yyyy format)

Column 4: To (end date in dd/mm/yyyy format)

With this information, I am computing for the following:

Compute the From and To columns using DATE function into Years, Months, Days format

Example:
From: 3/22/2021
To: 12/14/2022

Computed results should be 1 Years, 8 Months, 23 Days

Total years of work experience per employee

Sub total years of work experience of employee per category (i.e, if the employee is previously worked in Sales industry, there would be a separate sub total. And if that employee is also previously work for I.T industry, there would also be a separate sub total)

What if the date in Column 4 is present. The employee is currently employed. Can we use =today() formula in MS List.

I hope these complex questions can be done in MS List. If it can't be computed in Lists, can you suggest other O365 apps that can accommodate these type of information.

Thank you very much.
Sermae C. Platino 20 Reputation points

2023-08-01T08:56:34.63+00:00

Hi @Yanli Jiang - MSFT ,

I see. Thank you so much for all the help!
Yanli Jiang - MSFT 31,666 Reputation points Microsoft External Staff

2023-08-01T08:59:24.99+00:00

Hi @Sermae C. Platino ,

Glad to be of some help to you.

Have a nice day! :-)

Share via

Total sum for calculated column with multiple formula

1 additional answer

Your answer