cancel
Showing results for 
Search instead for 
Did you mean: 

Percentage Deviation wrong result!

Former Member
0 Kudos

Hi Developers,

In a query I'm using the standard Percentage Function: "Percentage Deviation". This function works wrong because if I calcul the formula manually with Excel the result on 40 rows of the query, the correct values are just for 4 rows!

Any ideas on this result error?

Is it possible to insert the symbol "%" in a cell without using the standard Percentage Function?

Thanks in advance!

Domenico.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

I dont know why % is not working in your query( I tested with 50 lines), but the formula for % is the below.

100 * (OPER1-OPER2)/OPER2

e.g.

OPER1; OPER2; %

48; 125;-61,6%

Vasso