Forum Discussion
chaichatp
Helper III
Helper IIIMultiple SUMX makes my table slow
I try to do Weighted score by multiplying SCORES of each category with Parameter then plus everything and becomes like this. Any suggestions? SCORE Simulated = SUMX('EQTY-SCORE',[SCORE Total] ...
chaichatp , My mistake table name left
SCORE Simulated = SUMX('EQTY-SCORE',([SCORE Total] * [EQTY-Prmtr-SCORE Value])+ ([Rank DefaultRisk] * [EQTY-Prmtr-IG Value])+ ([Rank4Allctn DDM IRR] * [EQTY-Prmtr-IRR Value])+ ([Rank4Allctn BBG LTG] * [EQTY-Prmtr-LTG Value]))+ SUMX('EQTY-Correl_EPS_10Yrs',([Rank4Allctn Crrl EPS3Yrs] * [EQTY-Prmtr-EPS3Yrs Value])+ ([Rank4Allctn Crrl EPS5Yrs] * [EQTY-Prmtr-EPS5Yrs Value])+ ([Rank4Allctn Crrl Price3Yrs] * [EQTY-Prmtr-Price3Yrs Value])+ ([Rank4Allctn Crrl Price5Yrs] * [EQTY-Prmtr-Price5Yrs Value]))
amitchandak
Super User
Super Userchaichatp , My mistake table name left
SCORE Simulated =
SUMX('EQTY-SCORE',([SCORE Total] * [EQTY-Prmtr-SCORE Value])+ ([Rank DefaultRisk] * [EQTY-Prmtr-IG Value])+ ([Rank4Allctn DDM IRR] * [EQTY-Prmtr-IRR Value])+
([Rank4Allctn BBG LTG] * [EQTY-Prmtr-LTG Value]))+
SUMX('EQTY-Correl_EPS_10Yrs',([Rank4Allctn Crrl EPS3Yrs] * [EQTY-Prmtr-EPS3Yrs Value])+
([Rank4Allctn Crrl EPS5Yrs] * [EQTY-Prmtr-EPS5Yrs Value])+
([Rank4Allctn Crrl Price3Yrs] * [EQTY-Prmtr-Price3Yrs Value])+
([Rank4Allctn Crrl Price5Yrs] * [EQTY-Prmtr-Price5Yrs Value]))
chaichatpHelper III
Helper IIIThank you but that didnt help it load faster. I might need to find out more what makes it slow. At least i know how to construct the SUMX formula correctly.