Skip to main content

Derived field to calculate percentages always show zero

Article # 3021521 - Page views: 72


Question / Problem: 

When creating a derived field to calculate percentage ((field 1 / field 2) * 100), the results are always zero. How can this be fixed?

Answer / Solution: 

This occurs because the source fields are not of FLOAT type. If you are sourcing from a database table, try creating a pre-calculated record based on that table, making sure the two fields in question are mapped as FLOAT in the record. Then load the data into the record and retest your derived field.

Applies to:  

Product Version
Insight 6.x / 5.x