exclude current month

[joeybird]

Hiya

have a kpi

I am trying to write something like this

sum({$< Order_Date -={$(Month(getdate()))}  >}Customer_ID)

I wish to exclude this months 'October 2015'  (When this post was written)  orders for customers

where am I going wrong

please help

[#2]

count({$< [Order_Date.Calendar.Month] ={$(=Month(AddMonths(today(),-1)))}  >}Customer_ID)

AddMonths(today(),-1) will give you last month.

caution though - the Month function will take out the Year portion - so if you have more than a years worth of data, it will look at multiple Septembers....

[joeybird]

Hiya

this still returns the value of 0

I try this, but it does not seem to minus order dates for this month

COUNT({$< Order_Date -= {$(=Month(today()))}>}Customer_ID)

what can be wrong?

please help

[#4]

hello

does:

COUNT({$< Order_Date <= {$(=AddMonths(MonthEnd(today()),-1))}>}Customer_ID)

work?

[joeybird]

Brill, thanks again, it worked x

Kind Regards