6 Replies Latest reply on Nov 26, 2018 7:12 AM by ShivaRam Chennapragada

    Calculated field help - IF and Count

    antony runc

      Hi

       

      I need two calculated field which essentially says:

       

      1) If date opened is in 2018, and case status is "open/active" and date suspended is populated with a date then number of records.

      2) if date opened is in 2018, and case status is "open/active" and date suspended is null (blank) then number of records.

       

      I would also like, if possible, to compare these to 2017, so I would end up with something like this:

       

                                                      2017      2018

       

      Suspended - open/active          2          1

      ongoing - open/active                0          1

       

      Thanks very much