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.