7 Replies Latest reply: Jul 27, 2015 1:01 PM by Sunny Talwar RSS

    How do I write the correct formula to find the quantity sold in the last six weeks?

      Hello,

       

      I am trying to find the quantity of items sold in the last six weeks. Here is what my formula looks like:

       

      =Count({<Max(Week([Year Month]))={>=Max(Week([Year Month])-6)}>}[Unit Sold])

       

      When I enter that formula in, it doesn't show the correct value. Can anyone help me fix my formula?

       

      Thank you