I am creating a basic income statement. I need to pull all the transactions for a specific month and the transactions for the fiscal year to date.
I put in a paramater for the user to select the the date range (say 5/1/2012 to 7/31/2012). I can easily get the fiscal year transactions but I am having trouble limiting the month ( 7/1-7/31). I tried this formula
If Month ({GLTransactionMasterList.GLTransactionDate}) = Month (Maximum({? Date Range})) then {GLTransactionMasterList.GLTransactionDebitAmount}
The formula give me an error that a statement is expected for the red print.
Any help is greatly appreciated.
IP Logged
