Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Sum total vs column total sum

This might be simple but need some help. I am trying to get a sum total of the column individual part cost x qty applied to ppm which should be a total of $2,543,433 but the total calculation shows $61815531900.79383, which is not what i want. Can anyone help me what i am doing wrong. Thanks

 

 
 
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

     

    The  individual part cost x qty applied to ppm is a calculated column or measure ?. 

     

    What is the output visual - Table or Matrix. 

     

    Please post your measures / cacluated column expressions to explore further.

     

     

    Cheers

     

    CheenuSing

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

     

    The  individual part cost x qty applied to ppm is a calculated column or measure ?. 

     

    What is the output visual - Table or Matrix. 

     

    Please post your measures / cacluated column expressions to explore further.

     

     

    Cheers

     

    CheenuSing

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi ChenuSing

      It is a Table

      INDIVIDUAL_PART_COST x QTY_APPLIED_TO_PPM = SUM('CQMS_MNC_DATA_V'[INDIVIDUAL_PART_COST]) * SUM('CQMS_MNC_DATA_V'[QTY_APPLIED_TO_PPM])
      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi Anonymous ,

         

        Remove the sum in your expression . It should be

         

        INDIVIDUAL_PART_COST x QTY_APPLIED_TO_PPM = ('CQMS_MNC_DATA_V'[INDIVIDUAL_PART_COST]) * ('CQMS_MNC_DATA_V'[QTY_APPLIED_TO_PPM])

         

        Check it out and let me know.

         

        Cheers

         

        CheenuSing