Skip to Content
0
Former Member
Jul 15, 2008 at 11:41 AM

Symbol of percentages in query

19 Views

Hi all!

I have a problem with the symbol of my percentages while designing my queries. Explanation as follows:

Line 1: -2......-66,66%

Line 2: 2.......66,66%

Line 3: 3.......100%

-


Total: 3.......100%

In this case the percentages are correct for me, but take a look at the next one:

Line 1: 2......66,66%..........-66,66% (correct value)

Line 2: -2.....-66,66%...........66,66% (correct value)

Line 3: -3.....-100%.............100% (correct value)

-


Total:.....3.....-100%.............100% (correct value)

The correct values should be the ones to the right. Do you know how to change the sign of some of the percentages to appear correctly in the query?

Thank you very much in advance