Implementing Calculation Like Excel

Question

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 thisSpending Activity | Quantity | PriceNew computer                1          $2500Its possible to achieve something like thisSpending Activity | Quantity | PriceNew computer                1          $2500-----------------------------Total Spending                             $2500Balance                                           $7500Many thanks------------------------------Syaeful Bahri------------------------------

EverettPatterso · Accepted Answer

Easy, you will need a setup like thisDepartment table - create fields for department name and total budgetSpending 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------------------------------

EverettPatterso · Answer

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

Sign up

Login to the community