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