Announcements
cancel
Showing results for
Did you mean:
Not applicable

## Set analysis: curent month sales

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???

1 Solution

Accepted Solutions
MVP

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

14 Replies
Not applicable
Author

Hi,

I believe it would be something like this:

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

Hope it helps!

Partner - Creator III

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

MVP

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

Not applicable
Author

HI;

Please do you have an exemple qvw ??

Thnks again.

MVP

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.

MVP

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

Not applicable
Author

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

MVP