### Examples using SELECT

I’m a high school Economics teacher and I’m trying to create a simple bank system to teach my students how to manage their finances. I’ve successfully created a database that will update a running balance after multiple transactions, but I have to enter negative numbers in the withdrawal amount column.

There has to be a way to word the following so it works...

Account.Balance is a formula field into which I put the following...

sum(transaction.amount where transaction.type is deposit) - sum(transaction.amount where transaction.type is withdrawal)

Note: Transaction.Type is a “choice” field with Deposit and Withdrawal. I have also put the numbers 1 and 2 into the above formula instead of Deposit, etc.

I have also tried the following in the “Trigger after update” part of my Transaction sub-table:

if Type=1 then Accounts.Balance+Amount else if Type=2 then Accounts.Balance-Amount

Hello,

I'm teaching business economics online and need help with the I have successfully created a simple checkbook with the Columns: balance, debit and deposit. Now, I need to created a database. Can I export my data from Pega Platform?

Adrian Altenburger > Intelligene official https://essays.agency

@jwlevy613

In the (double) accounting world all items are positive.

Anyway, if I understand you correctly, to get the number as negative try something like this:

if 'Transaction Type' = 2 then

Amount := 'Withdrawal Amount' * -1

I did something similar to this. Have you tried something like
sum(Account.Balance[Transaction.Type = 1].transaction.amount)-sum(Account.Balance[Transaction.Type = 2].transaction.amount)

What I did worked for me, but I haven't tested the above.

Beginning Economics education is too focused on theory. Once you get past the basic models, it would be better for students to learn about the US and world economies, from a descriptive standpoint. And to learn some basic economic history. This would produce better informed citizens and workers.

For example, no one who knows economic history would advocate making major spending cuts while the country is in a deep recession, as happened with the Tea Party Congress.
https://www.domyhomework4me.onl/

Beginning Economics education is too focused on theory. Once you get past the basic models, it would be better for students to learn about the US and world economies, from a descriptive standpoint. And to learn some basic economic history. This would produce better informed citizens and workers.

For example, no one who knows economic history would advocate making major spending cuts while the country is in a deep recession, as happened with the Tea Party Congress.
<a href="https://www.domyhomework4me.onl/">https://www.domyhomework4me.onl</a>

Beginning Economics education is too focused on theory. Once you get past the basic models, it would be better for students to learn about the US and world economies, from a descriptive standpoint. And to learn some basic economic history. This would produce better informed citizens and workers.

For example, no one who knows economic history would advocate making major spending cuts while the country is in a deep recession, as happened with the Tea Party Congress.

[url=https://www.domyhomework4me.onl/]https://www.domyhomework4me.onl[/url]