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

[tinkerz1]

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))