23 Replies Latest reply: Aug 20, 2018 4:42 PM by Wanyun Yang RSS

    sum up all sales before current month

    Wanyun Yang

      I have recent 3 years sales data, I'm trying to sum up all sales before August (current month) in these years. My function is:

      Sum({<Month={"<(=month(today()))"}>}Sales)

      The result is 0, I have no idea what's wrong. Any ideas?

       

      Thanks in advance!!