Calculate commission on values in a data row not working
I'm trying to calculate the Comm. $ (last column) based on the the Premium (first column) and the value the user inputs in the Comm. % field.
Comm. $ = (Premium * Comm. %) / 100
The issue is that I cannot get the calculation to happen when I use the Premium field from the data grid. If I replace Premium with a value, it works fine.
Comm. $ = (5 * Comm. %) / 100
This should be a pretty simple action, but for some reason I'm just not getting it.