Hy there, I do have a simple table called Ausgaben_Freizeit having the column Datum (date) and Summe (Number) for the amount and also a hidden field called Month that basically executes the month function on the field Datum.

I furthermore have a table called budget where I have the field Freizeit (Number) which sets the budget for the current month.

Now I would like to display the sum of expenses by month and the remaing budget which I normally would do by creating a separate view. However here it seems I have to create a table to do this? 

However I am already stuck at displaying the expenses by month. I only manage to get to display the month if I call the first function. Which of course doesnt make sense.

So what is the correct way to do this with the ninox db?