I have a formula in one column that is multiplying two columns together but the column with the formula shows a sum total of $0. Does anyone know how to fix this? You think it would just add what’s in the column but it’s clearly not acknowledging the number value in the cell.
Hi @cmasquared - that’s odd, as Formula columns will still show a total (sum, avg, etc.) in the footer of the group. What are the column types you are referencing in your formula? Are there any text qualifiers in your formula?
Thanks,
Mark
Hi @cmasquared ,
You can try this formula
({AMT 1} * {AMT 2})
It’s working fine for me
If you need any implementation support kindly contact us
MSquare Support
Visit us here
Youtube Channel