Forum Discussion

nix's avatar
nix
Helper I
2 years ago

sum column error

 

 

In 1st one steaming col the row value giving right but when i am using sum(steaming col) eaither by formula sum direct  or by creating a measure0 it is giving the 2nd pic's value which is not at all correct and higer then actual,why is it so

Need Help
Show and Tell

3 Replies

  • Kishore_KVN's avatar
    Kishore_KVN
    Solution Sage
    2 years ago

    Hello nix ,

    Please check the steaming column datatype and make it decimal number. 

    Once the values are fixed use SUMX for the measure instead of SUM as it is a Row Level Calculation. 

     

    If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!