asked on July 9, 2016
Hi,
When we load below data into flexmonster, the numeric columns are not showing aggregated functions like(Sum,Max,Min etc...).
Reason we found is whenever we have a value 0 in first object in JSON array, it's treating like text column.
As it is a big issue, Please make the fix available in next minor release?
[{"legal entity":"30FR","function":"0","marketing":4106097.6210000003,"pretax earnings":123323.44434,"r&d":0,"revenue (net)":40332397.6522529},{"legal entity":"32NL","function":"Manufacturing","marketing":0,"pretax earnings":414671.79097289604,"r&d":5465655.5889608,"revenue (net)":23321564.517543554},{"legal entity":"34LU","function":"LRD","marketing":5505809.096000002,"pretax earnings":4015966.5592195,"r&d":0,"revenue (net)":53336791.80493299}]
Thanks & Regards,
Sunilkumar.V
⋅ July 11, 2016
Hello Sunilkumar,
Thank you for the request.
Please confirm that you mean the issue with the "r&d" field.
If yes, the fix will be available in the next minor release (ETA Jul 18).
Also, as a workaround, you can explicitly define field types - https://jsfiddle.net/iansadovy/vtjpbsyh/
Regards,
Ian
⋅ July 11, 2016
Hi Ian,
yes, the issue is with "r&d" field only.
Thanks & Regards,
Sunilkumar.V
⋅ July 25, 2016
Hello Sunilkumar,
This issue was fixed in the 2.217 version.
It is available for download from our site - Download
Please let me know if it works for you.
Regards,
Ian
