1 Reply Latest reply on Jun 20, 2018 9:21 AM by Deepak Rai

    Calculate Total Cases & Current Open Cases

    Manoj RS

      Hi All,

       

      I have a requirement to create a tabular report with these columns - Case Type, Total Cases & Current Open Cases. (for last 12 months)

       

      The case type is a direct column which has list of case types and for Total Cases - I used this calculation COUNTD(Case Number) which works fine.

       

      For Current Open Cases - I used the below calculation. However, the aggregation is not working and the no's seem incorrect.

       

      { FIXED [Case Type] :  COUNTD (IF [Status] =  'Open'  then '[Case Number]' end)  }

       

      Can you please help?

       

      Note: I tried using INCLUDE function as well instead of FIXED.

       

       

      Thanks much,

      Manu