December 18, 2013 mellerbeck Set Analysis with alternate states This is an easy way to compare two data sets. The trick is to use the [Alternate State] syntax in your set analysis. sum({[Set B]< Tran_Date = {‘>=$(=Date(vSetBStartDate))<=$(=Date(vSetBEndDate))’}>} in_tran_qty) Share this: Email a link to a friend (Opens in new window) Email Share on Facebook (Opens in new window) Facebook Share on LinkedIn (Opens in new window) LinkedIn Share on X (Opens in new window) X Like Loading... Related