Hi all,

I've got two short questions I've been thinking about recently which I'd like to run past some of you more experienced members.

1) Case(), if more than one case is true, it will display only the first. How would I calculate if I want to show all that are true separated by "/"? e.g Case(3+3 = 6; "A"; 2+4=6; "B") -> "A/B"

2) Is there a way to repeat a "word" based on another field's number/count? e.g. number = 3, text = "word word word"

Thanks!

fmphysio

Edited January 7, 201016 yr by Guest

1.

Substitute ( 

List (

Case ( 3 + 3 = 6 ; "A" ) ; 

Case ( 2 + 4 = 6 ; "B" )

) ; ¶ ; "/" )

2.

Substitute ( 10^number - 1 ; "9" ; "word" ) 

This works for up to 404 repeats - for more, see:

http://www.briandunning.com/cf/942

Edited January 7, 201016 yr by Guest

comment, are you serious??? 9 min response time. That's amazing! Thank you so much.

I'm surprised at how simple the calculations actually are. You're a fm genius!

Thanks!

fmphysio

I am sorry, but I was reading another post and didn't get to yours until later... :)