What is wrong with this set analysis expression

Report Inappropriate Content · ‎2016-12-10

Why is it not working. Is there some syntax mistake

sum({$<Date_k={">=$(=date(max(Date_k)-300,'yyyyMMdd'))<=$(=date(max(Date_k),'yyyyMMdd'))"}>}QtyOnHand)

Shah

swuehl · ‎2016-12-10

Could you be a bit more specific what 'is not working' exactely means? No results, wrong results, etc?

First check that your dollar sign expansions return the expected values, correctly formatted matching the field value format of Date_k.

Second, if you make active selections in other fields, these may interefere with the set you define in your set analysis.

You may need to clear fields the user may select in (e.g. Month field).

It's explained in more details in

Related Topics