SUMPRODUCT SharePoint Calculated Column

Shelley B 136

Hello,

I need some assistance please, I'm trying to create a calculated column to perform a SUMPRODUCT like calculation.

I'm assuming that's the best option for what we're trying to achieve.

The column needs to sum the products delivered based on product name and return total delivered against the product name row, from there we use a calculated column to work out the outstanding products yet to be delivered:-

I'm stuck and any help would be appreciated

Accepted answer

Shelley B 136 Reputation points

2021-05-17T10:13:25.357+00:00

Thanks for your help Echo, I've just realised I can get the info required via a Power BI Report.
Please sign in to rate this answer.
Echo Du_MSFT 17,186 Reputation points

2021-05-18T00:39:40.453+00:00

Hi @Shelley B ,

Thanks for you reply.

I'm glad to hear that your problem has been solved. : )

If the answer is helpful to you, you can accept it as answer. The behavior will help others who meet the similar issue in the future quickly find the correct answer.

Thanks,
Echo Du

Echo Du_MSFT 17,186 Reputation points

2021-05-20T09:39:55.023+00:00

Hi @Shelley B ,

You can mark your answer. The behavior will help others who meet the similar issue in the future quickly find the correct answer.

Have a nice day!

Thanks,
Echo Du
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

1 additional answer

Echo Du_MSFT 17,186 Reputation points

2021-05-17T01:53:20.767+00:00

Hi @Shelley B ,

Welcome to Q&A Forum!

I recommend you to use the Number column, which has a built-in sum function. Other types of columns do not have this function.

Please following steps:

1.Create a Number column

2.Click on the Number column small arrow icon

3.Select Totals >> Sum

Thanks,
Echo Du

=========================

If an Answer is helpful, please click "Accept Answer" and upvote it.
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.
Please sign in to rate this answer.
Shelley B 136 Reputation points

2021-05-17T07:07:34.817+00:00

Hi Echo,

Thank you for the response, on the 'Totals' function there I don't believe there's an option to add the 'Outstanding' calculation next to the 'Total' i.e sum info.

For each part number of need understand how much stock has been delivered to day and then minus the delivered stock to them give me the outstanding value.

Echo Du_MSFT 17,186 Reputation points

2021-05-17T07:51:54.74+00:00

Hi @Shelley B ,

According to my understanding, you want to automatically calculate how many undelivered products, that is, automatically calculate the value of OutStanding.

Please following steps:

1.Create the Calculated column

2.Use the below Formula:

=[Delivered to date]-[Delivered]

Thanks,
Echo Du

Shelley B 136 Reputation points

2021-05-17T08:21:21.003+00:00

Hi Echo,

For the 'Delivered To Date' are you manually calculated the figure? if so, I need that to be an automatic calculation.

Echo Du_MSFT 17,186 Reputation points

2021-05-17T09:27:56.917+00:00

Hi @Shelley B ,

Thanks for you reply.

Based on my research, we could not use another calculated column in the calculated column, it is by design.

In other words, only one of “OutStanding” and “Delivered to date” can be a calculated column.

OutStanding： = [Delivered to date]-[Delivered]

Delivered to date: = [Delivered]+[OutStanding]

Thanks,
Echo Du
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

SUMPRODUCT SharePoint Calculated Column

1 additional answer

Your answer