Year = If([Query 1].[Accounting Period] <= 6;Max([Fiscal Year] -1);[Fiscal Year].I think you need something like Max() in your code. Try this code, if this is not working you can check this for your help.
aniketp 
(BOB member since 2007-10-05)
Year = If([Query 1].[Accounting Period] <= 6;Max([Fiscal Year] -1);[Fiscal Year].I think you need something like Max() in your code. Try this code, if this is not working you can check this for your help.
aniketp (BOB member since 2007-10-05)