Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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