I've just started experimenting with QV. I added a simple gross margin calculation (JanProfit/JanRev) and ended up with a lot of null values (or whatever a minus means).
Any help would be greatly appreciated.
That did it. Can you explain why however?
You need to tell it what to aggregate that's all. Do you want to sum your measure, count, count distinct etc? Because you could do count(JanProfit)/Count(JanRev) as well and it would intuitively produce different results.
I'm no expert however.
Retrieving data ...