Genx Posted February 13, 2007 Share Posted February 13, 2007 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 More sharing options...
comment Posted February 13, 2007 Share Posted February 13, 2007 You could do this by a custom function, but if you want a trail, try something like the attached. deductionSets.fp7.zip Link to comment Share on other sites More sharing options...
Genx Posted February 13, 2007 Author Share Posted February 13, 2007 (edited) 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, 2007 by Guest Link to comment Share on other sites More sharing options...
comment Posted February 13, 2007 Share Posted February 13, 2007 (edited) 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, 2007 by Guest Link to comment Share on other sites More sharing options...
Genx Posted February 13, 2007 Author Share Posted February 13, 2007 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. Link to comment Share on other sites More sharing options...
Genx Posted February 13, 2007 Author Share Posted February 13, 2007 (edited) 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, 2007 by Guest Link to comment Share on other sites More sharing options...
comment Posted February 14, 2007 Share Posted February 14, 2007 Eh ... ... the kids today ... ... no imagination whatsoever ... deductionSets.fp7.zip Link to comment Share on other sites More sharing options...
Genx Posted February 14, 2007 Author Share Posted February 14, 2007 Nevermind, I played a bit more and got it working Thanks again. deductionSets.zip Link to comment Share on other sites More sharing options...
Genx Posted February 14, 2007 Author Share Posted February 14, 2007 Lol sorry. Thanks though, love your work! Link to comment Share on other sites More sharing options...
Genx Posted February 14, 2007 Author Share Posted February 14, 2007 OOoooh yours has more useful fields!!! Anyway, I'll just be quiet now, Too much red cordial.. or coffee, whichever. Link to comment Share on other sites More sharing options...
comment Posted February 14, 2007 Share Posted February 14, 2007 Mine also doesn't do -a +a . Link to comment Share on other sites More sharing options...
Genx Posted February 14, 2007 Author Share Posted February 14, 2007 LOL, I was having a blonde moment... You have to realize, despite not being blonde i have a lot of those. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6282 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 accountSign in
Already have an account? Sign in here.
Sign In Now