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
Hi @Mario36
Got it. Seems to be exact match.
Workflow:
Hope this helps : )
Hi @Mario36 ,
You want the product of column B and column C ?
If yes, here is your solution. I attached a workflow. It uses a Formula tool to multiply both columns and output the result in a new column.
Can you tell me what is below highlighted doing ? how is it working ?
I was not able to figure it out">😐
Why is 1+ required?
Column C is the value what I want. It has a calculation which I need Alteryx to perform. Column B contains the values which are used.
@atcodedog05 Unfortunately even my team has no answers. This is a calculation which has been used historically.
@Mario36
Thats a steep hill then ">😐
I've tried something for which I'm getting close but not exact results. I'm not sure to have fully understand the computation. Tell me if it's okay or not !
I've checked and the differences are due to roundings.
So just by adding the + 1 before the multiplication, it works ! i don't get why ! 🙄
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 😅
Oh okay ! So better do anything else than multiplication in another tool when using doubles ! 🙂
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 😅
Oh okay, I get it ! Thank you for this explanation ! I should go back to doing some mathematics ! 🙂
This was slightly a complicated one and a black box 😅 so no worries.
@atcodedog05 & @Jean-Balteryx Thank you both for your expertise and thanks @atcodedog05 for your solution. Cheers.
You are welcome @Mario36 ! Sorry I didn't achieve the solution as @atcodedog05 !
