Problem with Group By?

[bwisealiahmad]

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

[pradosh_thakur]

try this

sum(total <%ProposalLine_%UkeID_Key>DagMatriseVerdi2018%)