Calculate difference in Alteryx

[stephen]

Hi Team,

I have a data as below from as seen below for FY B24  F24 and I need to prepare a WF to Calculate the Average of Nov & then Average of Dec, which i am now doing by below formula in excel

Is there a way in alteryx to calculate the formula

Attach is the file

[abacon]

@stephen Here is a forum showing the average function in use. The logic in Alteryx will be very similar to how you have done it in excel.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Average-Values/td-p/1114570

Bacon

[stephen]

Hi the solution is not correct, i first need to find out the difference in value and then the average. hope you seen my excel and how its calcualting the number 1st for nov and then it doing the average

[binuacs]

@stephen created a workflow similar to the given input 

[stephen]

Hi Binuas thanks for reply..

But my apologies, i am new in alteryx .. so i guess i could not explain correctly

I am attaching my file again..

So my output should be it should first concentane  commom filds and from months it should only select B25 & F24 and then find the difference for Nov AVg and then Dec AVG

Is it possible

[Qiu]

@stephen 
I dont quite the the meaning behind your logic of Excel but tried to copy the logic here.
I also added some annotation under the tools to show what is the intention.

No need apology and we all were beginners and still keep learning from each other. 😁