Subtotal calculation in reports

AppSheet AppSheet Q&A
1

I am generating a report in which I have 3 divisions of information

  • Category
  • Input/Output
  • Payment type (Credit card/casj/Transfer)

and according to this it shows me the information in the report table. I am looking to calculate the subtotal of each of these divisions and the instruction I am using is as follows.

<<SUM( SELECT(Notes[Total service],[Type_of_Payment]=[_THISROW].[Type_of_Payment]))>>

The above seeks to make the sum on the data that is throwing me in the table that are the operations by type of payment but it throws me zero. What am I doing wrong? If later I want to make the cut of the inputs and outputs to get the sum of them, where do

Thanks as always for your support

duda subtotal.png
duda subtotal.png3824×1917 461 KB

2

I believe it needs to be [_THISROW-1].[Type_of_Payment]

3

Many thanks @TeeSee1 unfortunately it didn’t work :disappointed_face: it does add up, but I don’t know what, but I’m sure it doesn’t add up to what I need. :downcast_face_with_sweat:

reporte 1.png
reporte 1.png662×646 31.2 KB

4

You might want to add another constraint [tipo_servicio] = [_THISROW-2].[tipo_servicio] as you have in the detail select expression.