An existing spreadsheet has a formula which needs to be implemented in SQL. The user note indicates 3 months compounding formula where each rows stores 1 month of data.
(PRODUCT(1+A1:A3/100)-1)*100
The formula does not have curly braces around it to make it an array formula.
I tried to break the formula by first starting with PRODUCT(1+A1:A3). However, it is not same as (1+A1)*(1+A2)*(1+A3). The results of this is way too high. Alternatively, I tried - ROUND(AVERAGE(A1:A3)+1,0). It matches with results for few combination of values but not the all.
To simplify the request, pls help to translate PRODUCT(1+A1:A3) to SQL or plain English.
(PRODUCT(1+A1:A3/100)-1)*100
The formula does not have curly braces around it to make it an array formula.
I tried to break the formula by first starting with PRODUCT(1+A1:A3). However, it is not same as (1+A1)*(1+A2)*(1+A3). The results of this is way too high. Alternatively, I tried - ROUND(AVERAGE(A1:A3)+1,0). It matches with results for few combination of values but not the all.
To simplify the request, pls help to translate PRODUCT(1+A1:A3) to SQL or plain English.
