Expression problem

mingyu — Thu, 19 Dec 2024 04:16:53 GMT

My table A's mainid is associated with table B's mainid, resulting in the PharmaBatchNo column of table B. The result I want to display is B PharmaBatchNo，SUM(A.ContractAmount), How to write an expression based on the number of rows in Table B?SUM (a. ContractAmount) should be displayed on each line.

Re: Expression problem

Vegar — Thu, 19 Dec 2024 05:51:21 GMT

You could look into the concept of sum( TOTAL <FIELD> VALUE_FIELD).

I will not be able to tell you in detail how ro do it but try something like this.

sum( TOTAL <ProductAPIContractNo> ContractAmount).

topic Re: Expression problem in App Development

Expression problem

Re: Expression problem