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 Spendin...
- 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
------------------------------
