Logic Help

[abhaysingh]

HI Guys need some help in logic,

this is the logic below,

sum({<LinkDate,LinkDate={'>=$(vFROMDATE)'},LinkDate={'<=$(vToDate)'}, ISSUE_MOEVMENT_FLAG={1} >} ISSQTY)

in this i am getting few values 0,

with respect to key PLANT+MATRIAL, if ISSQTY >0 than it should not display in the report.

what whould be the logic pls suggest

[tresesco]

Your expression looks not right to me. There has to be some correction. Could you share a sample qvw explaining the required output?

[amayuresh]

Try this,

=sum({1<LinkDate={">=$(=MonthStart(AddMonths(vFROMDATE)) <=$(=MonthEnd(vToDate))"}, ISSUE_MOEVMENT_FLAG={1} >} ISSQTY)

[amayuresh]

Provide sample data

[jonathandienst]

How are the two variables defined? Are they in the same format as LinkDate?

You can combine the LinkDate filter criteria into a single set criterion.

[Anonymous]

Not Sure about your requirement ,you can try like this

sum({<LinkDate={'>=$(vFROMDATE)<=$(vToDate)'}, ISSUE_MOEVMENT_FLAG={'1'} >} ISSQTY).

[engishfaque]

Dear Abhay,

Try this one,

=Sum ({<LinkDate={'>=$(vFROMDATE)<=$(vToDate)'}, ISSUE_MOEVMENT_FLAG={1}>} ISSQTY)

Kind regards,

Ishfaque Ahmed

[tyagishaila]

Hi Abhay,

If you are not getting desired output by this

=Sum ({<LinkDate={'>=$(vFROMDATE)<=$(vToDate)'}, ISSUE_MOEVMENT_FLAG={1}>} ISSQTY)

than please share sample data. There may be another issue.

Cheers

[abhaysingh]

Pls find the Sample Data

Date	Material	issueqty
01-01-15	M1	50
02-02-15	M2	10
02-01-15	M1	0
03-01-15	M4	0
05-02-15	M4	10

here i select date range 01-01-15 to 03-01-15 the output shud be

Date	Material	issueqty
03-01-15	M4	0

the logic is if KEY i.e Material is in the selected Date Range is =0 than it should show in the list only,

you can see Material M1 in two dates 01-01-15 and 02-01-15 the issue qty = 50 +0 , thats why it should not show.

Hope m clear

[tyagishaila]

What do you mean by

ISSUE_MOEVMENT_FLAG={1}