Percentage change between two columns

pmorto

Hello. I am trying to create a formula that will give me the increase or decrease between tickets in a quarter. I have the formula to count quarterly. I just need something to give me the variance between tickets during a quarter.

Q1 = 130 Q2 = 340 QoQ% = ?

L_123

=[Q2]@row/[Q1]@row ?

L_123

or if you want it to based on a positive negative scheme you could use

=1 - [Q2]@row/[Q1]@row