Problem financial function 'Rate'.

[rogeriobarbosa]

hello,

I have problems using the RATE function in QlikView, use the same function in Excel with the same values ​​against different results, anyone know if the QLIK have any restrictions on financial functions.

follows the example files

[swuehl]

Well, honestly, I don't know what you are calculating here per line, so I concentrated on the function syntax itself:

Please note that your excel function shows an ommited third parameter (two semicolons directly following each other). So you are using the 5 parameter version of the Excel function.

The QV function takes 3-5 parameter, so we need to enter all five. Since your Excel file doesn't show the cash equivalent as third parameter, I assumed zero for the QV function.

=  rate(

12-INDICE_MES,

-RangeAvg(above(sum(VENDA),0,RowNo())),

0,

sum(TOTAL ALL META) - RangeSum(above(sum(VENDA),0,RowNo())),

1

)    

And voila, I get the exact same numbers like in the excel file (after removing the minus sign before rate from your original expression).

Regards,

Stefan