2144444 - ORD reports (dashboards 3.0) are not correctly reporting on a value from a goal plan. - Goal Management

ORD reports (dashboards 3.0) are not correctly reporting on a value from a goal plan.

We have a custom field defined in our goal plan, and it is defined as a number. We use this is as a value in a SUM calculation also which is not working.

Example:

<field-definition id="stretch" type="number"

field-definition id="bizx-target" type="number"

The number is working correctly in Goals, and works as part of a calculation within Goals.

However, when we try to report on this same data via ORD reports (dashboards 3.0) the calculation does not work.

On goal side we allow customers to customize the id/label/type of custom fields in goal plan template. For this reason for such customize fields we only can store them in database as type=string since the field type could be changed at any time. The type NUMBER is not transportable to ORD, but is sent as TEXT type (varchar).