Percentage Deviation wrong result!

[Former Member]

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.

[Former Member]

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