Error while trying to create a custom field

Answered

Comments

1 comment

  • Avatar
    Michael Becker

    Hi Vibhu,

    Custom fields on tables work on per row basis, so if you use any mathematical operations, they will be performed for each row. If you use Aggregations like SUM or AVG, those by definition require a GROUP BY for each grouping column. Since you are operating on row level, it means you have to include all columns from this table that you do not use in aggregations in GROUP BY. I think you should either drop aggregations (remove SUM and AVG and just do what you need without them), or create a Custom SQL Expression, that will take data from your current table and do this aggregations to give you a resulting table(in that case you will need a syntax like that SELECT A,B, [Calculation] AS C FROM Table GROUP BY A,B). Hope it helps.

    Regards,

    Michał

    2
    Comment actions Permalink

Please sign in to leave a comment.