Calculate commission on values in a data row not working

Dee Skiver shared this problem 2 years ago
Solved

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.