Subtracting one row from another

Question

I need to subtract row 9 from row 8 into a new row. I thought it would be easy using multi-row formula, but apparently it is not.

I put in this formula [Row+8:EIN#1]-[Row+9:EIN#1]=[Row+10:EIN#1] for 10 EINs in 10 Columns to create a new row and I get "Parse error at char(58): Parse error

What's up?

dogregory · Answer

@pedrodrfaria Thanks for the attempt, but I think since it works by columns and not rows it won't fit my needs.

Thanks,

Doug.

pedrodrfaria · Answer

@dogregory is this what you are looking for?

I used a logic to filter by the name of the first column, but if it is always row 8 and 9, you can filter by those using the select records tool.

Pedro.

Subtracting one row from another.yxmd

dogregory · Answer

@pedrodrfaria will always be rows 8 and 9