Upvote 1

Calculate commission on values in a data row not working

Solved Dee Skiver 7 years ago

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.

Leave a Comment
Attach a file