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:
- ColumnA with value 42000
- ColumnB with 70%
- 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.