Hi,
I'm triyng to create a set analysis to disregard selections in the model, except selections in 3 fields, the set analysis also needs to apply only to part of the records based on sum(qnty)>=1.
My expression is as follows:
count({1< attribute_field= {1}, Store=$::Store, Date= {'>=$(=date(vDate1) <=$(=date(vDate2))'}, trans= {"=sum(qnty)>=1"} >} distinct trns)
I want to only count trans with qnty>=1, when the date is between the variables, attribute is 1 and to regard the current store selected.
Problem is, i get 0, which i know is wrong.
When applying the set analysis with the attribute, store and either date or qnty conditions i get results, but when i put both date and qnty conditions it fails.
Anyone has any idea to what the problem is?
Thanks.