Round a decimal negative number

[newqlik2017]

Final table is my initial output.

Result table is my final output.

Name is my dimension and rest of the columns are derived from a single expression (with set analysis). C1-C4 needs to be in $ format. Last 3 columns needs to be in %. This example is in excel. I need this in Qlikview. I got all parts covered, except the negative decimal numbers which I can't get into single digit percent, like in column (C4/C3) - 1.

Any ideas?

[swuehl]

How do you get to -6% by calculating 200/400 -1 ?

[swuehl · Accepted solution]

A simple format might do what you want:

=Num( YourCurrentExpression ,'0%')

[newqlik2017]

That was a typo, in my original post, while copying from FINAL to RESULT table.

[newqlik2017]

Hi Stephan, that works for case 1 (left side text boxes) but doesn't work for case 2 (right side text boxes).

[lorenzoconforti]

Can you post the exact expression behind the bottom right box?

[newqlik2017]

Here's the expression used =num(787 / 853 - 1, '#%') as in text box above. The result of text box 1, when applied this expression is text box 2. Ideally, I'm looking for 11% as the result.

[lorenzoconforti · Accepted solution]

Try changing # with 0

[newqlik2017]

= num ( (465/522-1), '#.%' )

This trick solved my issue. I needed a decimal before %.

[newqlik2017]

Both Stephan and Lorenzo's solution does work, including mine. Is there a way to award multiple answers as correct?