Jump to content

Custom Deduction Sets


Genx
 Share

This topic is 5707 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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 by Guest
Link to comment
Share on other sites

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 by Guest
Link to comment
Share on other sites

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 by Guest
Link to comment
Share on other sites

This topic is 5707 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.