Question1Replies48Views Devan Member since 2014 34 posts Virtusa Posted: 1 year agoLast activity: 1 year 1 month ago Closed Implementing CASE WHEN in RDHi All,There is a requirement to show the count of cases based on status. To be specific, count of new cases and count of all other cases. In SQL we can achieve using case when options. How can this be done in RD?Thanks,Aruldevan Reporting ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! Moderation Team has archived post This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question. Posted: 1 year agoRonLee_GCS PEGA replied to DevanYou can implement SQL "CASE ... WHEN" in a function alias, then apply it to the appropriate column.