10 Replies Latest reply: Jan 26, 2018 6:56 AM by pradosh thakur RSS

    Problem with Group By?

    Ali Ahmad

      4.PNG

       

      Hi,

       

      I have a fact table and my goal is to do following calculation:

       

      (23833,41 / 36) * 9

       

      What I am having issues getting into the Fact Table is 36. 36 is a sum of the rows in "DagMatriseVerdi2018%".

       

      I've tried to do a group by on %ProposalLine_%UkeID_Key and join back in but I get a really large number as you can see.

       

      LEFT JOIN (Temp_Fakta_2)

      Load

       

      [%PropsalLine_%UkeID_Key],

      Sum(DagMatriseVerdi2018) AS UkeMatriseVerdi2018,

          Sum(DagMatriseVerdi2018%) AS UkeMatriseVerdi2018%

         

      Resident Temp_Fakta_2

      Group By %PropsalLine_%UkeID_Key;

       

      Any help is appreciated.

       

      Best,

       

      Ali