• Are you grouping by Something else? Feels like something is missing.

    Check the attached test Report1, on a row by row basis, the expression is reflecting the amt correctly, so Not sure what the issue is.