Expression

[deepakqlikview_123]

Hello all,

Can you please tell me how below expression works,

=

count ({<Fab_Year = {$(=year(now()))},

Fab_Month = {

$(=month(now()))},

Fab_Day = {

$(=day(now()))},

Flag = {'2 Wheeler'}>}

CIS_NUMBER)
-

count ({<

Paint_Year = {

$(=year(now()))},

Paint_Month = {

$(=month(now()))},

Paint_Day = {

$(=day(now()))},

Flag = {'2 Wheeler'}>}

CIS_NUMBER)

thanks,

Deepak

[MK_QSL]

Below Expression will give you COUNT of CIS_NUMBER

Where

Fab_Year = CURRENT Year,

Fab_Month = CURRENT Month

Fab_Day = Today

and

Flag = 2 Wheeler

count ({<Fab_Year = {$(=year(now()))},

Fab_Month = {

$(=month(now()))},

Fab_Day = {

$(=day(now()))},

Flag = {'2 Wheeler'}>}

CIS_NUMBER)

The same logic is applied to 2nd expression...

Now the final result is Result of Expression 1 - Result of Expression 2