Current Month

[#1]

I want to reference the current month in my expression, so that I can sum sales that are current month -1,-2 etc

Can this be done?

[#2]

Hi,

you can get the current month with the expression: month(today())

Hope this help

Regards!

[swuehl]

Yes, should be possible.

you are talking about Sales month to date, previous month to date?

This can be done with set analysis, please have a look into

http://iqlik.wordpress.com/2010/11/27/the-magic-of-set-analysis-point-in-time-reporting/

Or also Set Analysis in the Help file.

Stefan

[#4]

I have tried this but it doesnt work?

sum ({$<SalesDate = {$(=month(today()),-2))

[#5]

I have tried this but it doesnt work?

sum

({$<SalesDate = {$(=month(today()),-2))

[pduplessis]

Is SalesDate a month number or a date? SalesDate cannot = Month# if its a date...

[#7]

sorry missed some of the expression

sum ({$<DisburseDate = {$(=month(today()),-2)

},

= {Active}, Main = {1}, AgreementAgeDays = {'>=45'}>}Sales)

[pduplessis]

try Sum({$<SalesDate={'$(=something that returns a date in the same format as SalesDate)'}>} Field)

[#9]

yes its a date

[swuehl]

Hi,

your sum misses the expression to sum, and the limitiation of dates might need a change:

like this?

sum({<SalesDate={">=$(=monthstart(today()))"} >} Sales)