Impossible to use this function with this field
OK using the demo of fastcube.
I'm trying to calculate weighted values based upon each records value. Surely I would add the weighting field as a measure, the sum as an aggregate function? When I do I get the above message 'Cannot use this function with this field'. How would I achieve this otherwise?
I'm trying to calculate weighted values based upon each records value. Surely I would add the weighting field as a measure, the sum as an aggregate function? When I do I get the above message 'Cannot use this function with this field'. How would I achieve this otherwise?
Comments
What is the field type?
Function "Sum" is not allowed for string type.
Oleg.
Just checked the table. The conversion had put the weights in as varchar, so I need to modify those...