Multi row formula

[VaishnaviGinni]

Hi,

I need help on below data set 

If first row has positive value entire table data should go to current qtr. tab

and second condition is - if first row has negative value entire table data should go to previous qtr. tab

Variance B/W current & prior Qtr.	New Acct Check	Variance
7048321566
-461812395.1	Remainder of net decrease in variance $(462MM) is due to deposits / withdrawals among thousands of customers, with no variance above / below	-0.07%
7510133961	Major factors identified	1.07%
7048321566	Variance 80%<120% should be explained	1%

[binuacs]

@VaishnaviGinni what is the field to check in the first row whether it is a positive or negative? 

[VaishnaviGinni]

Variance B/W current & prior Qtr. is field which we take

[binuacs · Accepted solution]

@VaishnaviGinni one way of doing this

[VaishnaviGinni]

Thank you so much for all your help.