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
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
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:
User | Count |
---|---|
56 | |
26 | |
24 | |
21 | |
21 |