Originally posted by DBlank

Sorry, my formula was to be used in the select expert to limit your data to only rows that would be last fy to date and this fy to date. Hence the returning of true or false.
If you want to get specific values the easiest way is to make two formulas out of either side of the or statement.
//last fy
If {Transaction.Date} in date(year(currentdate)-(if month(currentdate)<10 then 2 else 1),10,1) to dateadd('yyyy',-(if month(currentdate)<10 then 2 else 1),currentdate) then table.amount else 0
Now sum this to get your total
Sum(@last fy)

//this fy
If {Transaction.Date} in date(year(currentdate)-(if month(currentdate)<10 then 1 else 0),10,1) to currentdate then table.amount else 0
Now sum this to get your other total
Sum(@this fy)