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: Click to email a link to a friend (Opens in new window) Email Click to share on Facebook (Opens in new window) Facebook Click to share on LinkedIn (Opens in new window) LinkedIn Click to share on X (Opens in new window) X Like Loading... Related