Compute # of days difference based on Condition

[rdelmund]

Hi All, 

Need help to compute date difference if there's value on the Match field. Need to get the # of days difference on the transaction date column. Source should always be between Grab and AMEX with same amount. 

Transaction Date	Source	Amount	Match	# f days difference
1/23/2019	GRAB	102	2019-01-23,102.00,AMEX	0
1/23/2019	AMEX	102
1/23/2019	GRAB	103	2019-01-23,103.00,AMEX	0
1/23/2019	AMEX	103
1/29/2019	GRAB	104
1/21/2019	GRAB	105	2019-01-21,105.00,AMEX	0
1/21/2019	AMEX	105
1/24/2019	GRAB	105	2019-01-24,105.00,AMEX	0
1/24/2019	AMEX	105
1/24/2019	GRAB	106	2019-01-24,106.00,AMEX	0
1/24/2019	AMEX	106
1/22/2019	GRAB	107	2019-01-22,107.00,AMEX	0
1/22/2019	AMEX	107
1/22/2019	GRAB	107	2019-01-22,107.00,AMEX	0

Thanks, 

Rob

[DavidP · Accepted solution]

This formula should work. You can wrap it in an IF statement like IF !isEmpty([Match]) then ... else null() endif if you want