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

[NavinReddy]

Hi jagan

LOAD * INLINE [

    Date, Salary

    01/01/2014, 100

    03/01/2014, 200

    06/01/2014, 300

    07/01/2014, 400

    10/02/2014, 500

    11/02/2014, 600

    12/02/2014, 700

    13/01/2014, 800

];

=sum({<Date={">=$('01/02/2014')<=$('28/02/2014')"}>}Salary)

i Tried this expression This is also not working

Regards,

Niranjan

[jagan · Accepted solution]

Hi,

Try like this

Data:

LOAD

Date(Date#(Date, 'DD/MM/YYYY')) AS Date,

Salary

INLINE [

    Date, Salary

    01/01/2014, 100

    03/01/2014, 200

    06/01/2014, 300

    07/01/2014, 400

    10/02/2014, 500

    11/02/2014, 600

    12/02/2014, 700

    13/01/2014, 800

];

=sum({<Date={">=$(=Date(Date#('01/02/2014', 'DD/MM/YYYY')))<=$(=Date(Date#('28/02/2014', 'DD/MM/YYYY')))"}>}Salary)

Regards,

Jagan.

[NavinReddy]

Thank you jagan its working