I have 2 tables connected with each other. From table1 when I select Current month value in drop down. I want to sum the balance column values from table2 where month value is selected month value - 1.

Hi,

Can you post any screenshot of the tables? It's hard to grasp what actually is the data, and what's the desired output, which is crucial to write PQL code in order to get it.

Question 1 - how do you select "Current month value"?

Question 2 - Where, and how that selection is stored?

Question 3 - If current month value is like 1000 EUR, why you would like to see as a output rows with month value = 999 EUR (it's -1, compared to selected current month value)? Seems like bad idea, but I assume that's not a output you would like to see.

Best Regards,

Mateusz Dudek