6 Replies Latest reply on Apr 19, 2018 10:14 AM by Sonali chavan

    How to calculate the days if not calendar month

    Prashant Srivastava

      Hi Everyone,

       

      I am working on a report in which I have to provide the report monthly according to contract month.

      I was using this formula to get the details but unfortunately its not working.

       

      I am working with tableau server in which I fetch data from Jira, from there I have to calculate all PDs consumed in a month according to services/applications.

       

      Anyone can help me how to get the correct formula.

      M1=Contract Month 1

      15-xxx = Month start date.

      14-xxx = Month end date.

       

      IF DATE(2017-11-15) BTEWEEEN (2017-12-14) THEN M1

      END