1

I am using SharePoint office 365 modern site, I have to perform some business calculation and display the results in different column and get the sum total for this.

Scenario 1:

  1. ColumnA with value 42000
  2. ColumnB with 70%
  3. ColumnC to display results and also get the sum of total column values.

I tried write an formula in ColumnC, SP List Column Formatting as =([$ColumnA] * [$ColumnB]/100).

Scenario 2:

If I create an calculated column for this calculation. I am unable to find ColumnC in Totals under List settings.

Need help.

2
  • What is the data type of ColumnC? Aug 14, 2019 at 12:10
  • Currency data type.
    – Praveen
    Aug 14, 2019 at 16:37

1 Answer 1

0

It is not supported to sum a calculated column for total. Create a new C column as currency data column. You will need to use a Flow or workflow to automatically update value in Column C. Then you can use the built-in total in the list view to get the totals. A simple sample here: enter image description here

enter image description here

Update: For choice column, things will become a bit complex. You will need to covert the choice value to a float value. So the formula will be like:

mul(div(float(substring(triggerBody()?['X']?['Value'],0,2)),float('100')),triggerBody()?['B'])

Change the X to be the name of choice column and B to be the name of the integer column. enter image description here

3
  • I have 2 columns , first X is choice type with values as 10%,20%,30% and second column as integer is 60000. can you help me with formula
    – Praveen
    Aug 16, 2019 at 10:13
  • Can you share me this multiplication formula as shown above.
    – Praveen
    Aug 19, 2019 at 7:15
  • @Praveen, Sorry for the late reply. If you have a choice column, the formula will be a bit complex. It is mul(div(float(substring(triggerBody()?['X']?['Value'],0,2)),float('100')),triggerBody()?['B']) X is the choice column while the B is the integer column
    – Jerry_MSFT
    Aug 20, 2019 at 9:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.