7 Replies Latest reply: Jun 10, 2014 3:02 PM by Eduardo Sommer RSS

    Set analysis greater than less than

    Adam Haithcox

      I've seen many questions about this and tried the different solutions, but none have worked for me. I'm trying to get sales from the current quarter. Pretty simple. But I either get all sales or 0 sales. I've tried many variations. This is what I currently have:

       

      Sum({$*BM13 <Month={'>= $(=Month(QuarterStart(today()))) <= $(=Month(QuarterEnd(today())))'}>}[Sales Amount])

       

      Any ideas?