Hi,
I am trying to get acc. saldo per bank account, per day in a period. But I get stuck, I can't get the date formula right, can some one see what I am doing wrong?
Thanks,
Kristian
Date
Votes
1 comment
-
Jet Reports Historic Posts Hello Kristian,
I am not 100% sure I know what you are trying to do so take this reply with that in mind. I "think" you are trying to create rows of accounts and columns of dates, and where those intersect, get the net change - or activity for that account. If you just looking for the balance then use the date range of "..End Date" instead of the date range I used.
As you can see though, I nested the NP(Dates) function inside the NL(Columns) in order to list them out. I also used the Net Change field on the G/L Account table because then you can apply the Flow Filter (Date Filter) to it. Balance will always give you the balance as of today - never back in time.
I hope this helps!
Please sign in to leave a comment.