7 Replies Latest reply on Apr 4, 2016 8:01 PM by Vijaya Pediredla

    How to show the count of today's date minus Last 14days

    Vijaya Pediredla

      Hello All,


      I need to count  of today's date minus last 14days. Here i have used, but no luck. Can someone tell me how to count.


      WINDOW_SUM( COUNTD([Job Run Date]), FIRST(), 0) - TOTAL( COUNTD([Capability Objectid]))


      For example:


      CAPS i have today' count = 3

      Last 14day's  = 1


      I need to minus 3-1 =2.


      Any idea.