Martin Schoombee (6/7/2016)
Hi Phil,The best way is with a calculated measure, using a case statement to check if the sum (or aggregate) is less than zero.
It would also be possible to do this with scope statement, but that could be a bit more complex.
Thanks for the response, Martin. I'll give that a go. I was just reading about SCOPE and it does look a tad complex for a beginner.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.