to be more clear:
I want to
add budget for each category and month combination
then add transactions with month and category
and at the end to see and monitor monthly results budget vs spend per category:)
to be more clear:
I want to
add budget for each category and month combination
then add transactions with month and category
and at the end to see and monitor monthly results budget vs spend per category:)
Hi @Maciej_Alosat,
Im honestly a bit lost in your question but I will try to answer what I understand.
First, if you want to Link tables, then you have to Link them :grinning_face_with_big_eyes: This means you create a new field and link them accordingly.
HOWEVER, I think what you are looking for is Conditional Rollups. You can rollup the fields based on Conditions.
BR,
Mo
Hi @Maciej_Alosat,
Im honestly a bit lost in your question but I will try to answer what I understand.
First, if you want to Link tables, then you have to Link them :grinning_face_with_big_eyes: This means you create a new field and link them accordingly.
HOWEVER, I think what you are looking for is Conditional Rollups. You can rollup the fields based on Conditions.
BR,
Mo
sorry I didn`t explain this to well so
I got tables with Categories(5 records) and Month(2 records) - for grouping
Next there is table with budgets and each category has budget in each month so 10 records here
and last there is transactions table and each transactions is mapped to category and month.
Now question i how to see sum of of transactions for each records(category month comibnation ) in Budget table?
Cheers,
M
sorry I didn`t explain this to well so
I got tables with Categories(5 records) and Month(2 records) - for grouping
Next there is table with budgets and each category has budget in each month so 10 records here
and last there is transactions table and each transactions is mapped to category and month.
Now question i how to see sum of of transactions for each records(category month comibnation ) in Budget table?
Cheers,
M
You have to have linked fields then use rollups.
So you hve to link the tables together using Link to another record. What is the common item between the tables and what is the item you want to rollup by?
Make screenshots so I can understand it better