Impossible to use this function with this field

sjosjo
edited 12:11PM in FastCube
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?

Comments

  • edited 12:11PM
    Hi.

    What is the field type?
    Function "Sum" is not allowed for string type.

    Oleg.
  • sjosjo
    edited August 2010
    wrote: »
    Hi.

    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...
  • edited 12:11PM
    You can use event OnGetFieldConv to convert string field to float.

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.