Set Analysis

[m4u]

Hi all,

i have a "Calendar" table based on an AutoGenerate function who contains all dates in 2010.

then i have a few tables, like "orders", "invoices" etc, who ara joined also to the calendar table (through "date" field).

now, i need to show orders average the last month, trying to use this:

=Avg({1 <MonthNum={$(=Max(MonthNum)-1)}>} OrderTotal)

it doesnt work because i have orders on my table until "sep", and calendar table (which MonthNum is a part of) contains dates until the end of the year.

there is another way without manipulating the date on "orders" table.

thanks,

shlomo

[#2]

Maybe something like month(today()) - 1 in the set analysis. You might need an "=" before the "$", I'm not sure. I'm not a QV expert, but it's worth a shot.