Expression Help

[Anonymous]

Hi All,

I working on an xirr calculation and wanted to excluded company "ABC". I added '-' after Company to exclude 'ABC' but not getting any results.

=XIRR(aggr({<Company-='ABC.'>},Company,Amount),[Date])

Any feedback greatly appreciated!

Thanks,

Frank

[satishkurra]

Try this

=XIRR(aggr(Sum({<Company-='ABC.'>},Amount),Company),[Date])

[sunny_talwar]

Set Analysis doesn't seem right. Missing Curly brackets:

=XIRR(Aggr(Only({<Company-={'ABC.'}>}Amount), Company), Date)

[Anonymous]

Thanks Guys, still not working.

[cesaraccardi]

Hi,

What if you write it like this:

xirr(total<Company> sum({$<Company-={'ABC.'}>} Amount), Date)

Cesar

[Anonymous]

Didn't work.

[Anonymous]

Pls provide error you get when trying the above suggested expressions. When using aggr we need to have an aggregation function. You must have did a thorough check I am sure, but just want to rule out any typos here, is it ABC. or ABC ?

Try this:

XIRR(Aggr(Sum({<Company-={"ABC*"}>}Amount), Company), Date)

[Anonymous]

Thanks All for the replies.

I figure it out by removing Aggr and Sum from the above expression.