SyaefulBahri3
Qrew Trainee
5 years ago
Solved

# Implementing Calculation Like Excel

Hi all,

For example users have credit  \$10000 for every month. They can use and spend it every month for their activity.

There is table that record their spending each month like this

Spending Activity | Quantity | Price
New computer                1          \$2500

Its possible to achieve something like this

Spending Activity | Quantity | Price
New computer                1          \$2500
-----------------------------
Total Spending                             \$2500
Balance                                           \$7500

Many thanks

------------------------------
Syaeful Bahri
------------------------------
• Easy, you will need a setup like this

Department table - create fields for department name and total budget
Spending Activities table - create fields for date, spending activity name, quantity, price, and total price (formula, quantity X price)

The relationship would be Each Department has many Spending Activities. Create a summary field for Total Price.

On the Department table, create a formula numeric field called Balance, use the summary field Total Price - Total Budget

------------------------------
Everett Patterson
------------------------------

### 3 Replies

• That can easily be done with relationships and summary fields. Can you describe your app setup? Tables, relationships. etc.

------------------------------
Everett Patterson
------------------------------
• Hi Everett,

I'm creating this with excel but hopefully, it can show you the purpose

Each month, every department have 10,000 deposit for their monthly spending. Balance is just 10,000 - Total Spending

Many thanks

------------------------------
Syaeful Bahri
------------------------------
• Easy, you will need a setup like this

Department table - create fields for department name and total budget
Spending Activities table - create fields for date, spending activity name, quantity, price, and total price (formula, quantity X price)

The relationship would be Each Department has many Spending Activities. Create a summary field for Total Price.

On the Department table, create a formula numeric field called Balance, use the summary field Total Price - Total Budget

------------------------------
Everett Patterson
------------------------------