Show only the negativ values in a pivot table

[qlikconsultant]

Hi,

I have this formel in a table with 3  dimesions.

if(sum(A)+sum(B)<0,
sum(A) + sum(B), 0)

It works in a table but I have to change in a pivote table. 

The some values are missing because the total is poitiv any tips how can I fix that.

[marcus_sommer]

The following should work better as your approach but it may not prevent all NULL returns if data are missing:

rangemin(rangesum(sum(A), sum(B)), 0)

- Marcus