Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Incorrect Grand Total

Hello Everyone,

 

I've a scenario where I'd converted my negative number into the postive number but when I try to sum up this converted negative number with the positive number the grand total that I'm getting is wrong. Because since I've converted it to a positive number the grand total should increase instead what it's doing is still showing the difference number. And lastly when I apply the filter it's showing 0.00 intsead of showing the correct grand totals.

 

Below are the screenshots provided for both the scenarios.

 

 

 

 

Please help in this matter.

 

Thanks & Warm Regards,

Harsh

  • Anonymous , Try like

    new Sales -1= SUMX(summarize(Table,Table[Date],,Table[Doc Type],"_1", [Sales -1),[_1])

1 Reply

  • Anonymous , Try like

    new Sales -1= SUMX(summarize(Table,Table[Date],,Table[Doc Type],"_1", [Sales -1),[_1])