Forum Discussion
johnsmith92
4 years agoRegular Visitor
Rewrite SUMX? Poor performance when running calculations
Hi all, I have the following table: Queue AgentName Year Quarter Month Score1 Weight1 1 John 2021 1 January 100 6.87 1 John 2021 2 June 66,67 5.357 1 John 20...
Anonymous
4 years agoNot applicable
johnsmith92 I would get rid of IFERROR; instead check conditions that could cause an error before main calculation.
johnsmith92
4 years agoRegular Visitor
You mean I should use couple of nested IF statements?