Need to get the sum of a particular column by using Product formulae like in excel

[Sameer_Kanade8810]

Hi ALL,

 I have below data set where i need to apply a formulae like this excel =Product(1+A2:A4)-1

Which should give me a result 0.0150751249

Value 1
0.005
0.005
0.005

Is that possible please help

[Clifford_Coon]

Hi @Sameer_Kanade8810 ,

Something like this using multi-Row Formula

IF [Row-1:Result] = 0
THEN [Value 1]
ELSE (1 + [Value 1]) * (1+[Row-1:Result]) -1
ENDIF

2 versions, 1 hard coded, on with parameters

 

[acarter881]

Hello, @Sameer_Kanade8810.

You may use an iterative macro for this, although the multi-row formula may be easier.

The get data in shape workflow transforms the data for input into the iterative macro.

I attached the iterative macro and the workflow to run the iterative macro.

You can subtract any value you want from the result.

Iterative Macro:

Output: