Missing Total

[tmumaw]

Hi all,

I have a pivot table and I can't seem to get a total for one column.  Was wondering if anyone could help.  Here is my calculation:

if(Sum({<Cleared = {N}>} [Amount in LC_DMBTR]) = 0,
Sum({<[Special G/L ind_UMSKZ] = {I},[Document type_BLART] -={'DA'}>}[Amount in LC_DMBTR]) * 1 ) +
Sum({<[Debit/Credit_Flag_SHKZG] = {D}, [Document type_BLART] = {RV}>}[Amount in LC_DMBTR])

And yes I do have the totals button selected.\

Thanks

[m_woolf]

Just a guess. When you use + to add, if either expression is null the total will be null.

Maybe use rangesum instead?

Rangesum(Sum({<[Special G/L ind_UMSKZ] = {I},[Document type_BLART] -={'DA'}>}[Amount in LC_DMBTR]) * 1 ),
Sum({<[Debit/Credit_Flag_SHKZG] = {D}, [Document type_BLART] = {RV}>}[Amount in LC_DMBTR]))

Also, are you missing a closing parenthesis for your IF statement?

[tmumaw]

I used the rangesum on the last column.  All I got was the values in Payments Cleared.  I want to sum the overpayments column.

[m_woolf]

Can you share the qvw?