11 Replies Latest reply: Jan 9, 2018 8:46 PM by Anil Babu RSS

    Scoring system

    souad ouertani

      Hello,

      I have 3 variable and I need to calculate a score,

      (weighting)--->

                 VAR1 30%

                 VAR2 30%

                  VAR3 30%

      and the score must be <= 100 for example 90/100, 50/100 who can help me with ideas
      thank you

        • Re: Scoring system
          Anil Babu

          Not really thinkable from this? Can you post little more content

            • Re: Scoring system
              souad ouertani

              Hello Anil

              iin fact I need to calculate score by client
              VAR1: MMM
              VAR2 VRD
              Var 3 senior in relationship
              for example client x:
              MMM: 500.0        
              VRD: 200.5          
              Senior 5 years

              • Re: Scoring system
                souad ouertani

                Score:

                load 

                CLIENT_ID,

                MMM,

                VRD,

                RELATION,


                MMM/(MAX (MMM))*100 as MMM1,

                VRD/(MAX (VRD))*100 AS VRD1,

                RELATION/(MAX (RELATION))*100 AS RELATION1

                from

                [C:\Users\90160\Documents\document\CrditConta\*17.xls];

                Score1:


                load


                CLIENT_ID,

                MMM,

                VRD,

                RELATION+MMM1+VRD1 AS iNITIAL_Score



                resident Score;


                DROP TABLE Score;

                Score_final:


                load


                CLIENT_ID,

                MMM,

                VRD,

                (INITIAL_Score)/MAX(INITIAL_Score)*100 AS FINAL_Score



                resident Scor

                DROP

                TABLE Score1;

                  • Re: Scoring system
                    Anil Babu

                    Perhaps this?

                     

                    Score:

                    load CLIENT_ID, MMM, VRD, RELATION

                    from

                    [C:\Users\90160\Documents\document\CrditConta\*17.xls];

                     

                    Right Join (Score)

                    Load *, RangeSum(MMM1,VRD1,RELATION1) as INITITAL_Score;

                    Load CLIENT_ID, MMM, VRD, RELATION

                    MMM/(MAX (MMM))*100 as MMM1,

                    VRD/(MAX (VRD))*100 AS VRD1,

                    RELATION/(MAX (RELATION))*100 AS RELATION1

                    Resident Score Group By CLIENT_ID, MMM, VRD, RELATION;

                     

                    Final:

                    NoConcatenate

                    Load * Resident Score;

                    Right Join(Score)

                    Final:

                    Load CLIENT_ID, MMM, VRD,

                    INITIAL_Score/Max(INITIAL_Score)*100 as FINAL_Score

                    Resident Score Group By CLIENT_ID, MMM, VRD;

                     

                    Drop Table Sample;

                     

                    Note:

                    1) Group By Won't work while load table itself

                    2) To get that you need Resident from first table to get Max value from fields on behalf of table

                    3) The same i copied that table into new table

                    4) Finally, I did same again like 2nd point.