Recent content by Dragonscar

Thank you all for your help. I think I've finally got it working! Now if I can only figure out how to replicate the solution in other situations! <VBG> Laura

Thank you all for your help. I think I've finally got it working! Laura

I think I may have solved the riddle. Please, guys, correct me if I've done something silly that may come back to bite me, but here are the formulas I'm using: MTD: LastFullMonth YTD: If {SOP30200.DOCDATE} in Cdate(2003,06,01) to dateadd("m",-12,maximum(lastfullmonth))... LYMTD: if...

Okay, now my complete ignorance is going to show, but I can't get the (?Fiscalyr) parameter to be accespted as a date or date/time. When I put the date parameter into the formula, I just get the old "A number, currency amount, date, time, or date-time is required here." message.

Thanks for the tip, Brian. That works with the selection for the entire report, but then what do I use in the formula fields for the columns, which is where I've been having the problem? The report is a sales history & comparison, e.g.: Customer MTD LYMTD Variance YTD LYYTD Variance...

I've browsed through the threads and so far havent' found an answer to my dilemma. I am trying to compare LastFullMonth this fiscal year with the same month last fiscal year and fiscal year to date through last month with last years fiscal year-to-date through the corresponding month. Since...