Calculate difference in Alteryx

Question

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

Book1.xlsx

Qiu · Answer

@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. 😁

0527-stephen.yxzp

stephen · Answer

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

Book1.xlsx

binu_acs · Answer

@stephen created a workflow similar to the given input

difference_26052025.yxmd