I am trying to do a simple formula = Total * Rate. However, the total in the row does not work. Does anyone know how to change the formula so it totals properly, please?
I understand its using the total percentage to multiple the total total, but I am not sure how to change it to get the total in the row. Help please
Here is the formula I am using:
[Rate] * [Total] ,
[Rate] * [Total]