Yearly Flux formula

Question

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 · Answer

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

Khristian_Evans · Answer

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 · Answer

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.