Logic Help

[abhaysingh]

Hi guys ,

Need help here, i am attaching the sample application here, please go through once , what i required is when i give date range it shud give the item count excluding the current selection.

Let say i have select one date 01-01-2015 and second date 01-04-2015 , than count of item code shud come 9, with in the date range count shud not display rest shud display.

pls suggest

[Peter_Cammaert]

Try this expression in your text box:

=Count({$-<Date={">=$(=min(Lindate))<=$(=max(Lindate1))"}>} itemcode)

However, there will be some side effects you will need to take care of.

Peter

[Gysbert_Wassenaar]

=count({1-<Date={'>$(=only(Lindate))<$(=only(Lindat1))'}>}itemcode)

[Peter_Cammaert]

Note that it may look "ugly", but the expression will even work with the NULL dates you seem to have...

[abhaysingh]

Hi,

Thanks for support

load * Inline          /////////////////////////////////////Txn Table

[Date,itemcode,value,plant

01-01-2015,123,10,1001,

01-02-2015,124,20,1002

01-03-2015,125,30,1003,

01-04-2015,126,40,1004

01-05-2015,127,50,1005

01-06-2015,128,60,1001,

01-07-2015,129,70,1002

01-08-2015,130,80,1003

01-09-2015,130,90,1004

01-10-2015,129,100,1005,

01-11-2015,131,00,1005,];

right join

Tab2:          /////////////////////////Master Table

load * Inline

[itemcode,plant

123,1001

124,1002

125,1003

126,1004

127,1005

128,1001,

129, 1002

130, 1003

130, 1004

129, 1005

111,1001

112,1002,

1123,1005,

131,1005];

In the Txn table if Item code value is 00 than it shud also come as Non Moving count, How to include it in expression?

[sunny_talwar]

May be this:

NoConcatenate

Final:

LOAD * ,

          Month(Date) as Month,

          If(IsNull(value) or value = 00, 'NonMoving', value) as NonMoving,

          If(IsNull(Date), 'NonMoving', Date) as DateNonMoving

Resident Tab1;

DROP Table Tab1;

[sunny_talwar]

Actually my bad, I have no idea what you are looking for. The above might not be what you are looking for.