checkboxes

[jibi]

Hello all of you!

i have a small difficult... I'm ..french

and an other problem with filemaker

Problem and question:

I have a check boxe with numeric values

I created a calcultation with result, but..

when I do a multi check, when many boxes are checked,

the calculation take just the value of the first checked boxe!

how to get the sum of all the values checked?

im not clear, I kwnow

jb

thanks

[comment]

Can't help you with the first problem...

For the other one, try:

Let (

list = "0, " & Substitute ( checkBox ;

[Ender]

If not using FM7, I think you'll need to check for each number value as if it were text, and add the values they represent, like:

Case(Position("

[jibi]

woua

that sounds good, like a troll in the lord of the ring

i'll try to try this

thank you man

[jibi]

Let (

list = "0, " & Substitute ( checkBox ;

[jibi]

Case(Position("

[comment]

It's a calculation. Define a calculation field and paste the formula into it. Replace the word checkBox with the name of your checkbox field. Set the result to number.

Here's another possible formula:

Evaluate ( Substitute ( checkBox ;

[jibi]

i had the 6 version

since your last post, i updated in 7..

so i updated my profil too

the 7 version is very slow.. and the preview mode is gross

but.. i found your functions, the result is strange

I'm impressed with your very short formula

I try to understand

thanks