3 Replies Latest reply on Jul 20, 2015 8:20 PM by PruthviReddy

    Trailing twelve months filter not working as expected

    PruthviReddy

      Guys,

       

      All OOB reports come with Trailing Four Quarters but if the current quarter just started then the future months will have no data.

      if this is Q4 and has July, aug and sept - as aug and sept are in the future there is no data. so we only see 10 months.

       

      My req is if we are in July15 - I want to see all months in from July14

       

      I implemented as the below logic but its not working - these are filters

       

      Enterprise Period is greater than  @{ENTERPRISE_PERIOD_YEAR_AGO}

      AND Enterprise Period is less than or equal to @{CURRENT_ENTERPRISE_PERIOD

       

      The result i am seeing is only one month that is July 15 - can you guys please tell me where i am doing wrong - Please check the attachment for the result

       

      Thanks

       

      1.JPG