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.
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.