Helical Insight 5.0 Decimal Values not showing in Cross Tab

Technical queries
, , ,
#1

Hello Team,
I am using Helical Insight 5.0. While using cross tab visualization my decimal values are not showing and are getting rounded off.
NOTE : These values appears fine in TABULAR visualization.
How to fix this issue?
See images below for Reference :

image

But in crosstab it is not appearing with decimal values
image

Thank you,
Netta.

#2

Hello,

We see that you are having NULL values in that field. This is default behavior of the plug-in that if it encounters any NULL records in the fields then it will try to treat that column as VARCHAR/TEXT and hence you see this behavior.

You can fix this by adding a filter which will not show any null values OR apply db function to replace NULL data with ZERO.

Thank you,
Helical Insight.