How to Calculate with Month Number

[#1]

Trying to divide Sales thru the end of the last month by the number of months, but I cannot get this to work.

(Sum({$<_YTDAsOfLastMonth={1},Year={$(=Max(Year))}>}[Invoiced Order Net Revenue])) / (Num(Month(vEndOfLastMonth)))

The first half of this formula before the division sign works, but when I try to use a variable to create the month number for the last month, and divide, it doesn't work.  I'm sure I'm missing something little, so I'd appreciate any help.  Thanks.

[#2]

Try with this:

(Num(Month($(vEndOfLastMonth))))

[#3]

Good idea, as I thought about the $ too… I just tried (Sum({$<_YTDAsOfLastMonth={1},Year={$(=Max(Year))}>}[Invoiced Order Net Revenue])) / (Num(Month($(vEndOfLastMonth)))

And it still doesn’t work.

Thanks,

Shelley

Shelley Smith | Manager, Business Intelligence and Analytics

Spacesaver Corporation

DIRECT:: 920.563.0548 | CELL:: 608.751.4295 | TOLL:: 800.492.3434

FAX:: 920.563.0712 | WEB:: www.spacesaver.com

[#4]

Can you post a sample qvw?

[stigchel]

The function Month expects a valid Timestamp as parameter, the variable is probably text?

try

Month(Date#('$(vEndOfLastMonth)','YourDateFormat'))