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

[amayuresh]

I think due to your condition it is not showing any value.

As per your requirement, I am using expression as

=if(sum({<MyDate={">=01-01-15 <=02-01-15"}>} issueqty)=0,1)

if we consider date range 01-01-15 and 02-01-15, then there is no material having sum of issueqty is 0.

So it is not showing any output.

if we consider date range 01-01-15 and 03-01-15, then there is material M4 having sum of issueqty is 0.

So it is showing in output.

[#3]

Hi Abhay,

One field should be referenced only once in set analysis. so ,

LinkDate={'>=$(vFROMDATE)'},LinkDate={'<=$(vToDate)'}, is not correct

instead it should be : LinkDate={">=$(vFROMDATE) <=$(vToDate)"}

Also, you should aggregate the sum of issueqty wrt Material.

You can try this:

=Aggr(<Your Expression> ,Material)

In this case,

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

[abhaysingh]

it is not giving me desired output, could you take the sample data and provide me the qvw pls

[tresesco]

May be like:

= Sum({<LinkDate={"=Sum({<LinkDate={'>=$(vFromDate)<=$(vToDate)'}>} issueqty)=0"},

Material=e({<LinkDate={"=Sum({<LinkDate={'>=$(vFromDate)<=$(vToDate)'}>}issueqty)>0"}>})>} issueqty)