Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Trying to create a text object with the following:
sum(sales) - sum(budget)
The number should be negative, but it comes out as a positive integer.
Thoughts?
I think the only reason can be an accidental '-' minus in the expression or the values in the fields are already negative
could you post your qvw?
I think the only reason can be an accidental '-' minus in the expression or the values in the fields are already negative
Too long of a day.. Just realized after staring for a half hour that I didnt modify my set to only include this year. I'm all set now! Thanks, Daniel.
Hi David,
it will be a great help for us to check your problem if you can attach the file you are working with?