Compare two rows and adjust for $0.01 rounding

Hi all,

I'm trying to compare two rows where the "Name" and "Traveled To" columns are the same. (Net Pay = Earnings column less all the other columns) I need to compare the Net Pay lines in the 2 rows. If there is a difference of 1 cent, I want to adjust the Lived State Tax column for the 1 cent. Then I would just put in another formula tool to recalculate the Net Pay column so they now match. I've tried the Multi row formula but couldn't come up with a formula that would work. Any help would be greatly appreciated! Thanks.

Net Pay = Earnings less all the other columns

Compare 2 rows.yxmd

Common Use Cases

Accepted answers

fmvizcaino

Hey @ELPC ,

Here it is.

Best,

Fernando Vizcaino

Compare 2 rows.yxmd

All comments

fmvizcaino

Hey @ELPC ,

Here it is.

Best,

Fernando Vizcaino

Compare 2 rows.yxmd

JarekSkudrzyk

Hi,

I have done the comparison using a combination of summarize, formula and cross tab tools - please find attached (cross tab tool allows the workflow to function properly even when new columns are added)
Hope this is helpful.

Compare 2 rows_solution.yxzp

JarekSkudrzyk

Sorry, did not notice that the question has already been answered:)

fmvizcaino

No worries @JarekSkudrzyk . The more answers and different solutions, the better!

ELPC

Thank you so much! That worked.

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

michael_weaver 335

Hollingsworth 335