Set analysis: curent month sales

[#1]

Hi;

I need to get the sum of Salesfor the current Month.

So if I look at the data today, I want to get the current month's data,to calculate a KPI that mean :

• Sales of february 2014 * 25/ Number of day

Number of day: from start day of current month to today.

That mean "sales since the start of the current month *25/ 13 ( exemple for today).

I don't want to change sum sales every one I select a date from calendar to see another indicator.

I am using the following set analysis but it doesn't seem to be working .

any suggestions???

[#2]

Hi,

I believe it would be something like this:

sum({1<Month={$(=Month(Today())}>} [Sales Field]/Day(Today()))

Hope it helps!

[luis_pimentel]

=sum({<Month={$(=Month(Today())}>} [yoursalesfield]) * 25 / Day(Today())

[MK_QSL]

=SUM({<[Invoice Date] = {'<$(=Today())'}, InvoiceMonth = {'$(=Month(Today()))'}>}SalesField) * 25/Day(Today())

[#5]

HI;

Please do you have an exemple qvw ??

I try all your answer but it dosen't work .

Thnks again.

[MK_QSL]

Better if we have your QVW so that we can give you answer on the same.

You can attach a sample file or an excel file with reduced or dummy data.

[MK_QSL · Accepted solution]

Please check enclosed file which will show you sample data and your requested result.

[#8]

Thank You Manish;

It Works , Just I add  InvoiceDATE = {'$(=DATE(Today()),InvoiceYEAR = {'$(=YEAR(Today()))'} to have no changes when I select onather Year and day for another KPI .

ThnKS

[MK_QSL]

Glad that my help solved your problem.

[#10]

Please, just one thing: that function doesnot take into account this Day ; when I select 14/feb/2014 , I have 0 in all KPI for that function and when I add InvoiceDAY = {'$(=DAY(Today()), that does not work .

How can I solve this please?