Product function on Alteryx

[Mario36]

All, I am trying to replicate the Excel Product function to be incorporated on Alteryx. On the attached Excel file, column B which is the Value column has to be used to perform the calculation on Column C which is the Product column

[Jean-Balteryx]

So just by adding the + 1 before the multiplication, it works ! i don't get why ! 🙄

[atcodedog05]

Hi @Jean-Balteryx 

You are taking -1 in rounding multiplication. I am doing -1 separately in formula tool after rounding multiplication. Thats making the difference. I guess that's the cause 😅

[Jean-Balteryx]

Oh okay ! So better do anything else than multiplication in another tool when using doubles ! 🙂

[atcodedog05]

My calculation is considering 

([Row-1:Result]+1) * ([Value]+1)

Yours:

([Row-1:Result]+1) * ([Value]+1) -1

You are taking the -1 rolling multiplication which is impacting. It should be applied after. The calculation becomes different.

Hope this clarifies 😅

[Jean-Balteryx]

Oh okay, I get it ! Thank you for this explanation ! I should go back to doing some mathematics ! 🙂

[atcodedog05]

This was slightly a complicated one and a black box 😅 so no worries.

[Mario36]

@atcodedog05  & @Jean-Balteryx 
Thank you both for your expertise and thanks @atcodedog05  for your solution. Cheers.

[Jean-Balteryx]

You are welcome @Mario36 ! Sorry I didn't achieve the solution as @atcodedog05 !