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.
- 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).
If I create an calculated column for this calculation. I am unable to find ColumnC in Totals under List settings.