Hello, I am using Helical Insight 4.1 enterprise edition GA. I am trying to use a money field and do a sum on it, however it is giving an error.
What is the problem?
Thank You,
Sesa.
Hello Sesa,
As we saw this is happening because your at your DBlevel the datatype is marked as money. Hence it is being recognized as varchar and infront of all the data it is appending a $. That is why only groupby and count is working on it, nothing else.
Option 1: You can make the changes in the dblevel and make it integer.
Option 2: At custom column level you can write nested expression to remove the $ from it, then cast it to int and then do a sum
Option 3: The same thing you can even do at metadata level.
Thanks,
Helical Insight.