• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Column total not matching sum of rows

jmont031

New Member
HI



So, total not matching sum of rows.



In images the £406k should be £404k. Have tried HASONEVALUE, HASONEFILTER, ISINSCOPE. Now getting a total of £625k.



totally confused.. Also, the measure (Tiered) Old in image attached has [Individual return values] which is cuustomer and behaviour specific. Different whatif's are applied to adjust customers individual return values



Many thanks

JIMG_1800-compressed.JPGIMG_1801-compressed.JPGIMG_1803-compressed.JPG
 
Without the data model structure and bit of sample data, but hard to help.

Though my guess, would be SUMX() that's your issue. SUMX is evaluated in each row context. From what I see in your screen shots. You don't need SUMX but just SUM([Recharge Value (Tiered) OLD])
 
Back
Top