Formula for basic subtraction based on type of income

[cmcclellan · Accepted solution]

I couldn't find the 3 Section 1256 values you reference, but this should help show you how to do it:

[DavidP · Accepted solution]

How about this approach:

Create a [Row order] column and assign as follows:

if [Line] = 'Taxable Income Subtotal (0)' then 1
elseif [Line] = 'Net Income Per Financial Statements' then 2
elseif [Line Detail] = 'Section 1256 Futures Sold - 60% Reclass to LT' then 3
elseif [Line Detail] = 'Current Year Section 1256 Contracts MTM' then 4
elseif [Line Detail] = 'Prior Year Section 1256 Contracts MTM - Reversed' then 5
else 0 endif

Filter out all [Row order]=0 rows and sort by Partner Key Id and Row order.

You can now change the sign for Total Amount for all Row orders except 1 and sum them with a summarize tool, grouping on Partner Key ID.

Some funds only have items 1 and 2, so you need to decide what to do with those.

Workflow attached.

[Michaelovermyer]

T!his worked perfectly, thank you!

[Michaelovermyer]

T!his worked perfectly as well, thank you!