I have two tables. One is a table of invoice. There’s a [PAY] and [PAY TYPE]. I have another table that will sum up for the day. [Pay] is an amount, [Pay Type]= “credit”. I want to create a virtual row that sums up all the credits for the day.
select all with [pay type] = “credit”
sum up [Pay] if [Pay Type] = “credit” and [date] = today
Can somebody help with the expression?
My guess: sum(select([PAY TYPE] = CREDIT, [PAY], TRUE))
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |