12/05/2019, 6:26 PM
Its not working, shows all zero's

Gregory Jones

12/05/2019, 6:44 PM
take a look at answer id 34691 in suite answers. i believe you have to convert the posting period to a date to do the comparison
Oh wait, that's not it. Seems like you'd want to set the date comparison as criteria so you'd only return transactions within that time frame, then just bring quantity in as your result. Just tried it out as only a result column, and had a bunch of 0s, but for transactions outside of the time frame specified.