Derived field to calculate percentages always show zero
Article # 3021521 - Page views: 72
3021521
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 |