Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
='(' & if(IsNull(num(count(DISTINCT {$<Link_Flag={'Resolve'}, TicketStatus={'Resolved','Closed'},Process={'$(vProcess)'}>} TicketID)/
count(DISTINCT {$<Process={'$(vProcess)'}>} TicketID),'###.##%')),
0,
num(count(DISTINCT {$<Link_Flag={'Resolve'}, TicketStatus={'Resolved','Closed'},Process={'$(vProcess)'}>} TicketID)/
count(DISTINCT {$<Process={'$(vProcess)'}>} TicketID),'###.##%')) & ' )'
To begin with replace the if statement with the alt function:
='(' & alt(num(count(DISTINCT {$<Link_Flag={'Resolve'}, TicketStatus={'Resolved','Closed'},Process={'$(vProcess)'}>} TicketID)/count(DISTINCT {$<Process={'$(vProcess)'}>} TicketID),'###.##%'),0) & ')'
Then if that still gives an error, which I assume it will, post a document that demonstrates the problem. Without looking at the expression in the context of your document it is not possible to tell what is wrong.