Pesty sumx with absolute value

Hi,

I have tried to use HASONEVALUE but this problem is little different.

I have negavtive number coming in column

image

AB Error 2. I want to create a sum on it’s absolute value. So instead of 14,489 I should see 20,415.

Thanks,
-Ritesh

Hello @rit372002,

Thank You for posting your query onto the Forum.

Below is the formula provided for the reference -

Absolute Value (Correct Totals) - Harsh 1 = 
SUMX(
    SUMMARIZE(
        'Historical Fcst' ,
        'Historical Fcst'[ITEM_NUMBER] , 
        'Historical Fcst'[LOCATION] , 
        'Date'[Start of Week] , 
        "Grand Total" , 
        [absolute value] ) , 
[Grand Total] )

And also providing below the screenshot of the result -

I’m also providing a link below where a great post was created by one of our expert member @Greg about how to fix the incorrect totals.

Hoping you find this useful and meets your requirements that you’ve been looking for. :slightly_smiling_face:

Note: In order to view the entire post, please click onto the link and not onto the “Expand/Collapse” button.

Thanks and Warm Regards,
Harsh

2 Likes

This is absolutely amazing!!! Thanks so much @Harsh

Hello @rit372002,

You’re Welcome. :slightly_smiling_face:

I’m glad that I was able to help you.

Thanks and Warm Regards,
Harsh