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]

try <MonthStart(Today())

instead of -=Month(getdate())

[tresesco · Accepted solution]

You can't compare date field with month value. Rather, create a month field in the script (if already not there) and try expression like:

Load

          Month(Oredr_Date) as Month,

          ....

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

[Kushal_Chawda]

try

=sum({$< Order_Date ={"<$(=monthstart(max(Order_Date )))"} >}Customer_ID)

[joeybird]

Hiya

brill thanks Tresesco  !

and team too

Kind Regards

[joeybird]

Have got additional issue

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

how can this be altered to show for previous months?

so plot total against each month of the year?

please help

[tresesco]

Try like:

Dimension: Month

Exp: sum({$< Order_Date ={'$(>=YearStart(Today())<=MonthEnd(Today(),-1))'}  >}Customer_ID)

[joeybird]

Hiya

no joy with the above, any more ideas

just get -

please help

[#9]

sum({$< Order_Date ={'$(>=YearStart(Today())<=AddMonths(MonthEnd(Today()),-1)))'}  >}Customer_ID)

think i've got all the brackets in the right places!

[joeybird]

hiya

I think its an issue with my master calendar

need to re-arrange this please some how

I have come close with this

count({$< [Order_Date.Calendar.Month] ={$(=Month(today()))}  >}Customer_ID)   e.g I get 10

the logic would say count({$< [Order_Date.Calendar.Month] -={$(=Month(today()))}  >}Customer_ID) but I get 0

please help