Yearly Flux formula

[Khristian_Evans]

Hi, I need help with configuring a formula to flux 2 separate years by month, so in screenshot below I will need a flux of row 1 and 3, 2 and 4, 5 and 7. Please let me know if anyone can be of assistance. Thanks in advance! 

P.S. the outcome of rows 1 and 3 should be around (-40)

 

[Vinayp29]

Hey, what do you mean by "flux of row 1 and 3"? Could you simplify?

[Khristian_Evans]

A difference between Jan 2023 and Jan 2024 Pricing - so the flux would be -129.37 - 61, the highlighted portions. But I will need the flux for every month of the year

[aatalai]

@Khristian_Evans 

try crosstab grouping by month and auction and make the year the new column headers and sum price as value.

That might help. Let me know how you get on

[Vinayp29]

You can filter Auction column for rows which contains "BRA". Then from True node, use summarize tool to group by Month and sum of sum_price. I hope this helps. 

[Khristian_Evans]

I've done that and it gave me this, now all I have to do is a formula to flux Jan 2023 and Jan 2024 

 

[Vinayp29]

Now from filter F node, apply the same process as done with T node. Then join both the results using Join tool.