5 Replies Latest reply: Jan 10, 2017 8:35 AM by Dave Melillo RSS

    Greater Than Today

    Dave Melillo

      I am trying to only sum subscription amounts where the subscription end date is greater than today to get a true view of our customer subscription amount day by day.

       

      I referenced this post: Greater than today date

      to create the set analysis below, but it is not working.

       

      Any ideas?

       

      =sum({$< [Subscription End Date] = {">= $(=Date(Today(),'MM/DD/YYYY'))"}>}[Amount])

       

      - dave