IF Statement and Set Analysis

[Anonymous]

Hi All,

I need some help with IF statement and Set Analysis.

I want below expression with exclusion(1) to incorporate with the bottom expression (2). Both of these expressions works, I just added a variable for user input on the bottom expression(2).

(1)

XIRR({<Company-={'*XYZ.*'},[Type]-={'Income:','Expense:'}>} Amount,[Date])

(2)

XIRR(If(Date = Makedate(2015, 12, 31), Amount - Fabs(vIRR), Amount),Date)

Any input will greately appreciated!

Many Thanks,

Frank

[Gysbert_Wassenaar]

XIRR({<Company-={'*XYZ.*'},[Type]-={'Income:','Expense:'}>}  If(Date = Makedate(2015, 12, 31), Amount - Fabs(vIRR), Amount),Date)

[Anonymous]

Hi Gysbert,

it's not working. Below is what I have. I replace the makedate to '12/31/2015'.

=XIRR({<Company-={'*XYZ*'},[Trans Type]-={'Income: Other','Expense: Other, Miscellaneous'}, [Date]-={"$(=vMinDate)"}>}If([Date]='12/31/2015',([Amount] + $(vIRR)), [Amount]),[Date])