Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculation should be Negative...

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?

1 Solution

Accepted Solutions
danieloberbilli
Specialist II
Specialist II

I think the only reason can be an accidental '-' minus in the expression or the values in the fields are already negative

View solution in original post

4 Replies
danieloberbilli
Specialist II
Specialist II

could you post your qvw?

danieloberbilli
Specialist II
Specialist II

I think the only reason can be an accidental '-' minus in the expression or the values in the fields are already negative

Not applicable
Author

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.

Not applicable
Author

Hi David,

it will be a great help for us to check your problem if you can attach the file you are working with?