Forum Discussion
SUMX
Dear all, I have a question regarding SUMX in relation with memory issues. I made a small table in which is displayed amount A, an amount B and C=MAX(A-B,0) for key users of a system. These ...
But your definition of C doesn't say anything about summing. It just says "take the diff of A and B and if it's greater than 0, use it". And that's exactly what it does in the totals too. Total of A is lower than the total of B, hence 0 is being used.