Thanks for all your suggestions. I have followed Madawc's advice but when I run the report I am getting Bad Date format string on the Param_Date formula field.
Is it because the period field that I am trying to set to Date is held as a string in the database???
Can anyone tell me the syntax to calculate the last 12 months rolling total. The report parameters are period e.g. 01, 02, 03 etc and a year parameter. If the user selects period 06 in 2003 then I want the total to be for the last 12 periods e.g. period 06 - 12 in 2002 and periods 01 - 06 in...
Can anyone tell me the syntax to calculate the last 12 months rolling total. The report parameters are period e.g. 01, 02, 03 etc and a year parameter. If the user selects period 06 in 2003 then I want the total to be for the last 12 periods e.g. period 01 - 06 in 2002 and periods 01 - 06 in...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.