Get Free Trial

Cannot Sum on Mixed Float and (blank) column

Corwin Sheahan asked on June 29, 2018

Hi there! 

We’re seeing an issue where the user cannot sum the values in a column where there are blank entries. See .gif for details. We would like at least a configuration option to skip blank entries altogether, rather than render nothing in the pivot. 


1 answer

Dmytro Zvazhii Dmytro Zvazhii Flexmonster July 2, 2018

Hello Corwin, 
Thank you for your question. The reason for such behavior is that “List Price” column does not have number type. We recommend setting type number for the “List Price” field. Please find the information of setting data types for JSON data here: In case you prefer using CSV data type please follow the following article: Also when switching to the compact view make sure that the “List Price” field is set to measures when configuring the slice.
Please let us know if everything works fine for you.

Please login or Register to Submit Answer