Good afternoon. There are two applications in the first one, transactions from customers are counted there are two fields, this is the transaction date and the transaction amount. In the second application, I need to make two calculations, the first to count the transaction amount for the current day, respectively, the information would be updated every day, and the second calculation that counted the amount of transactions for the current month and this calculation should be updated monthly.
For example, on 07.01.2023 I conducted 5 transactions in the amount of 2,000, and on 08.01.2023 I conducted 10 transactions in the amount of 5,000. Accordingly, in the first calculation, I should have had an amount of 2,000 yesterday, 5,000 today, and tomorrow, respectively, a new amount for the current date.
And in the calculation for the month there should be an amount of 7,000, and on 01.02.2023 it should become 0 because the month will change and there were no transactions in February yet. And when they appear, they will have to be counted.
I hope you will help me to cope with this task myself. I can't.
Please sign in to leave a comment.