Hi guys,
I have created a saved search to show bank account balances at the end of the past 3 months. a column for the current balance, one for the balance at the last day of last month, one for the last day of the month before and one for the last day of the month before that.
My first column is just a sum of all posting transactions on the bank account. This is fine.
My second column uses the following formula and works fine - Formula (currency) / Sum / case when {trandate} <= LAST_DAY(TRUNC({today}, 'MONTH')-1) then {amount} else 0 end
My third column uses the following formula and gives me the same result as my second column - Formula (currency) / Sum / case when {trandate} <= LAST_DAY(TRUNC({today}, 'MONTH')-2) then {amount} else 0 end
Shouldn't the -2 mean it is now only looking as far as 2 months ago? Why is it not working?
Any input would be greatly appreciated
Thank you
Chris