Dear visitor, despite the COVID-19 outbreak, our team continues operating at full speed.

Also, here is the form where you can apply for a special discount and we will contact you with possible options. Stay safe and continue achieving your business goals.

Fill the form
Get Free Trial
Get Free Trial

Numeric columns are not showing aggregated functions.

kumar 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

3 answers

Public
Ian Sadovy Flexmonster 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

Public
kumar July 11, 2016

Hi Ian,
yes, the issue is with “r&d” field only.
Thanks & Regards,
Sunilkumar.V

Public
Ian Sadovy Flexmonster 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

Please login or Register to Submit Answer