Christian Coppe Posted June 19, 2006 Share Posted June 19, 2006 Hi, I try to develop a custom function in order to distribute a number based on a sequence, with separators. An example - the number is 17 - the sequence is 5 - the separator is "X" --> the distribution should be 5 X 5 X 5 X 2 The total of the numbers is 17 and each sequence is separated by "X". The distribution ends by the Mod(number ; sequence) This is the recursive function I developed, without success : Distribution(numbr; rythm) Let([ M = numbr ; R = rythm ; RI = Mod(M ; R) ] ; Case( RI = M ; RI ; R & " X " & Distribution((M - R) ; R)) ) Doesn't work... Find attached my test file : you will see that the results are far from being expected... Any suggestion will be greatly appreciated ! Christian test_sequence.zip Link to comment Share on other sites More sharing options...
comment Posted June 19, 2006 Share Posted June 19, 2006 (edited) I can't find my way through your calc. I think you want something like: Distribute ( number ; divisor ) Case ( number > divisor ; divisor & " + " & Distribute ( number - divisor ; divisor ) ; number ) Edited June 19, 2006 by Guest even simpler Link to comment Share on other sites More sharing options...
Christian Coppe Posted June 19, 2006 Author Share Posted June 19, 2006 Thanks for your answer. Unfortunately, it doesn't work beter than mine... Christian Link to comment Share on other sites More sharing options...
comment Posted June 19, 2006 Share Posted June 19, 2006 "doesn't work beter" is not a good description. Please state your input, your expected result, and the actual result returned. Link to comment Share on other sites More sharing options...
Christian Coppe Posted June 19, 2006 Author Share Posted June 19, 2006 Sorry, I just re-tried, and the conclusion is that I'm stupid your solution work fine ! I inverted the two data in the formula... Many thanks for your help ! Christian Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6521 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