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