help: divide a list into other two

[salvomic]

(05-19-2015 10:14 PM)Didier Lachieze Wrote:  As in your program example you were testing L1(j)<0 and L1(j)>0 I assumed you wanted to discard the zeros.
So, where do you want the zeros to fall? In both lists?

I think only in flpos, positive...

precisely, to calc MIRR I must have a list of positive values (and 0) and a list of negative, in the same order of original.
Actually I've this list {-180000, 100000 (5 times), -100000 (5 times), 0 (9 times), 200000}
that's {-180000, 100000, 100000, 100000, 100000, 100000, -100000, -100000, -100000, -100000, -100000, 0,0,0,0,0,0,0,0,0, 200000}
The 9 zeros are period to discount...

EDIT
(see here page 193)
positive list must also have a first element prepend, zero:
{0, 100000, ..., 0, 0, ..., 200000} but this is another 0 (fix, I think)

However, maybe the leading zeros are ok, I'm trying another way...