Hi Guys,

This belongs either here or under scripts, I'm not fussed as to the solution but would probably prefer calc based.

What I essentially want to do is have values (percentages and dollar values) removed or added to / from an initial value to produce an end result -- Given that percentages are used, order matters here and I can't quite wrap my head around this. The deduction set is user specified. Custom Functions for this would also probably be useful.

I've attached a simple sample because my wordiness usually lacks sense To add an entry to the deduction set just go to the deductions layout, I've just used a Cartesian here sooo..

Any help is appreciated, Thanks Guys!!

deductionSets.zip

You could do this by a custom function, but if you want a trail, try something like the attached.

deductionSets.fp7.zip

No that's perfect comment, my brain's just not spinning to well for me lately.

Just one more question... What happens if the two percentage values have to be taken off the same original value. E.g. in my example, the first two had the order "1". The reason was that the 10% was taken off the 5000, followed by the 8% taken off the 5000 followed by the rest.

Thanks a million!

Edited February 13, 200718 yr by Guest

Mhmmm... OK, for each child record, take the initial (parent) value, and add the sum of previous results (from siblings of lower order). Then do the calc, but return only the difference, not the final value.

In parent, sum the child results, and add them to the initial value.

---

It's actually better this way, since it also allows you to report the actual sums deducted/added.

Edited February 13, 200718 yr by Guest

Okay, I'm going to have to pick at this tommorrow, lol, lack of sleep really hurts after a while.

Thanks again comment, your a genius.

Hi Comment. I've actually had a chance to pull apart the file but after much considering of the above statement... I just can't follow your line of thought.

EDIT: Completely my fault, not in any way yours

Edited February 13, 200718 yr by Guest

Eh ... ... the kids today ... ... no imagination whatsoever ...

deductionSets.fp7.zip

Nevermind, I played a bit more and got it working

Thanks again.

deductionSets.zip

Lol sorry. Thanks though, love your work!

OOoooh yours has more useful fields!!!

Anyway, I'll just be quiet now, Too much red cordial.. or coffee, whichever.

Mine also doesn't do -a +a .

LOL, I was having a blonde moment... You have to realize, despite not being blonde i have a lot of those.