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,