Skip to main content
suryanarayana
suryanarayana
Helper ⭐️
October 31, 2019
New Idea

Can we have functions inside case statement for a rule

  • October 31, 2019
  • 3 replies
  • 72 views

We have encountered this scenario multiple times, somehow we are solving it by creating number of tasks in a rule.For example for a customer we have to derive {[(Count of Cases Closed where Jira Issue ID != Null)/Total Cases Closed] . we had to write 3 tasks to do this . where as simple function inside case statement .For one customer we had to goon and write up-to 15 tasks.

      3 replies

      Nagaraju Panyam
      Helper ⭐️
      February 11, 2020

      Even we got a scenario to compare the two columns from the source data set ,for that we have to create multiple transformation to acheive . If we find a solution that will be really help full.

      phani_kumar
      phani_kumar
      Gainsight Employee ⭐️⭐️
      February 11, 2020

      Yes, it really helps us if we have a comparison of fields in our existed functions.

      kumaranbcak
      Contributor ⭐️⭐️⭐️⭐️⭐️
      October 12, 2021

      Case statement must allow us to do some calculations in it. Allowing us to say this or that is not an optimal Case statement scenario. This will significantly reduce the number of transformations in a rule. This is something really useful and really basic necessity. 

      Muthu Kumar Karuppiah
      Terms & ConditionsAccessibility statement