Menu
Download Free Trial

Numeric columns are not showing aggregated functions.

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