Forum Discussion

chaichatp's avatar
chaichatp
Icon for Helper III rankHelper III
6 years ago
Solved

Multiple 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] * [EQTY-Prmtr-SCORE Value])+
SUMX('EQTY-SCORE',[Rank DefaultRisk] * [EQTY-Prmtr-IG Value])+
SUMX('EQTY-SCORE',[Rank4Allctn DDM IRR] * [EQTY-Prmtr-IRR Value])+
SUMX('EQTY-SCORE',[Rank4Allctn BBG LTG] * [EQTY-Prmtr-LTG Value])+
SUMX('EQTY-Correl_EPS_10Yrs',[Rank4Allctn Crrl EPS3Yrs] * [EQTY-Prmtr-EPS3Yrs Value])+
SUMX('EQTY-Correl_EPS_10Yrs',[Rank4Allctn Crrl EPS5Yrs] * [EQTY-Prmtr-EPS5Yrs Value])+
SUMX('EQTY-Correl_EPS_10Yrs',[Rank4Allctn Crrl Price3Yrs] * [EQTY-Prmtr-Price3Yrs Value])+
SUMX('EQTY-Correl_EPS_10Yrs',[Rank4Allctn Crrl Price5Yrs] * [EQTY-Prmtr-Price5Yrs Value])
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

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

4 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    chaichatp , Try if this works better 

    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])+
('EQTY-Correl_EPS_10Yrs',[Rank4Allctn Crrl Price3Yrs] * [EQTY-Prmtr-Price3Yrs Value])+
('EQTY-Correl_EPS_10Yrs',[Rank4Allctn Crrl Price5Yrs] * [EQTY-Prmtr-Price5Yrs Value]))
      • amitchandak's avatar
        amitchandak
        Icon for Super User rankSuper User
        6 years ago

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