Setanalysis

[NavinReddy]

Dear All,

I am using set analysis to display current month salary

=sum({<Date={">=$(=MonthStart)<=$(=MonthEnd)"}>}Salary)

But using this set analysis im getting last month Salary Also

could some one help me to display current month salary only

Thanks In Advance

Niranjan

[#2]

Hi Niru,

For Ex,

=sum({<Month ='Jan'>}Salary)

[#3]

Hi,

Hope try this,

Sum({$<Month={$(=Max(Month))}>}[salary])

[NavinReddy]

Hi Kumar,

I need to display current month starting date to Till date Salary

Regards,

Niranjan

[#5]

Are you trying to show the all the dates between start date and end of the month?

[NavinReddy]

yes Sneha ......

[#7]

You can create two variables for current month start date and end date.

And the use can use expression like

=sum({<Date={">=$(=vStart)<=$(=vEnd)"}>}Salary)

[preminqlik]

hi try this

sum({<Year={$(=max(Year))},Monthnum={$(=max({<Year={$(=max(Year))}>}Monthnum))},Date={'<=$(=max(Date))'}>}Salary)

here for  Monthnum, do in backend like below :

num(Month(Date))               as               Monthnum

[NavinReddy]

Yes i Followed the same way

you can check my expression above i m following the same technique

=sum({<Date={">=$(=MonthStart)<=$(=MonthEnd)"}>}Salary)

but im getting last month salary values also

plz help me

Regards,

Niranjan

[jagan]

Hi,

Check whether dates in the variables and Date dimension are in same format and also check the values in the variables.

If date format differs then it wont work as expected.

=sum({<Date={">=$(=MonthStart)<=$(=MonthEnd)"}>}Salary)

Regards,

Jagan.