SyaefulBahri3
6 years agoQrew Trainee
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
------------------------------
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
------------------------------