stimulsoft calculated column with aggregate function

The return type of an expression is determined by the DataType of the. We often use aggregate functions with the GROUP BY and HAVING clauses of the SELECT statement. An expression to calculate the value of a column, or create an aggregate column. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. An aggregate function in SQL returns one value after calculating multiple values of a column. Fields with text values can never be aggregated in VALUES. Please refer to the Website Terms of Use for more information in this regard.Ĭonfindential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. If you want to add a text value for each row to a table, use a calculated column. (Note: I have tried different calculations between columns of the same Datasource 1 and it works fine, but when I try to inlcude this column B that comes from Datasource 2, it does not work). The point is that I cannot calculate column A Column B. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. The data of the column B is shown OK in the table (according to the relation). Disclaimer: The information provided on and affiliated web properties (including the DevExpress Support Center) is provided 'as is' without warranty of any kind.

Stimulsoft calculated column with aggregate function