Jump to content

My function doesn't work...


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

Recommended Posts

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 :P

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

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

This topic is 5648 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.