Selection not supported.

[#1]

Dear all,

Sum(Aggr(

If(Status = 'ACTIVE,

    NetWorkDays(Date(Date#(LON_DATE)), Today()),

    NetWorkDays(Date(Date#(LON_DATE)), Date(Date#(SET_DATE))))

, Dim1, Dim2))

This expression has been used in my application.

Results of the same does not changed according to the selection made in the selection box (Month and Year).

Rgds,

Priyantha.

[avinashelite · Accepted solution]

Does the Month and Year are in the Aggr condition

[Anonymous]

Hi Priyantha,

If I am not wrong  you are missing measure in the expression

Correct me if I am wrong

If(Status = 'ACTIVE,

    NetWorkDays(Date(Date#(LON_DATE)), Today()),

    NetWorkDays(Date(Date#(LON_DATE)), Date(Date#(SET_DATE))))

'MEASURE', Dim1, Dim2))

[#4]

THX.