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
