topic Re: Calculation based on rows in App Development

Calculation based on rows

Saurabh_K14999 — Thu, 02 Feb 2023 09:54:35 GMT

Hi All,

I have a table

ID,SALE,AMOUNT

1,5,50

2,4,100

In this table i want to show calculation based on 1st and 2nd row in the 3rd row as 3.

ID,SALE,AMOUNT

1,5,50

2,4,100

3,9,150

I want to show addition of 1st and 2nd row in the third row with id as 3.

Regards,

Or — Thu, 02 Feb 2023 10:31:21 GMT

Not sure how well this will apply to whatever it is you're trying to do, but at least for this case,

Table1:

Load ID, Sale, Amount From SomeTable;

Concatenate

Load Sum(ID) as ID, Sum(Sale) as Sale, Sum(Amount) as Amount

Resident Table1;