0 Replies Latest reply: Nov 15, 2016 10:44 AM by Neil Woodham RSS

    How would you turn a formula with many branchs into a fixed set

    Neil Woodham

      Hi,

       

      I want to turn some of my formula's in tables that will update on reload but will not be changed when list boxes are clicked on.

       

      Some have many branches, do I have to write {<1>} in every formula on each branch?

       

      I also have the below formula as totals in text boxes, is there a quick way to fix the set?

       

      Thanks,

       

      Neil.

      count(
      aggr(
      if(
      ReferenceNumber=
      FirstSortedValue(
      if(
      (
      Match(OpenCase,'YES') AND Match(BusinessArea,'(FR) SPL') AND
      (
      Wildmatch(LoggedByGroup,'0*') AND (Wildmatch(EscalateTo,'*TPA*') OR LEN(EscalateTo)=0)
      )
      )
      OR
      (
      Match(OpenCase,'YES') AND Wildmatch(EscalateTo,'*5/5*'))
      ,
      ReferenceNumber),LoggedDate)
      ,
      ReferenceNumber
      )
      ,
      ReferenceNumber,LoggedDate))