Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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?