I created a quizz where I calculate IMC.

I have comma as a decimal mark.

I used a formula to attribute the interval of IMC

The IMC formula is

{round(Weight/(Height*Height/100/100),2)}

To evaluate IMC interval I have this formula

{if(IMC<25,0,if(IMC>=25 and IMC<=30,1,if(IMC>30,3)))}

With comma as decimal mark the if condition does not work. It looks like the if function "thinks" the comma near 30 ( IMC<=30,) is a decimal mark instead of a parameter.

With decimal mark as dot it works fine

I tried to use fixnum(IMC) but didn't work

Is there a way to make this work with decimal mark as comma?

I send my quizz as an attach

Thanks

Try introducing some decimal positions and spaces.

Can you send a lss ?

Comma have issue, but i never see such issue …

I just sent you an example

Hi,
Don't show "all on one page".

With this - shortened - equation
{if(IMC lt 25, 0 ,if(IMC le 30,1,3))}




or



Joffm

Thanks it worked

The problem was that on last IF I didn't write a value case the condition was false. If I write a value the formula works.

But you were right I didn't need the last if.

Thanks

Joffm wrote: Hi,
Don't show "all on one page".

In my opinion : it must work in all in one page, i didn't really see the issue in expression,

But here , as separator seems to broke the test.


To fix the issue : you can use «{if((round(Weight/(Height*Height/100/100),2))<25, 0 ,if((round(Weight/(Height*Height/100/100),2))>=25 and (round(Weight/(Height*Height/100/100),2))<=30,1,if((round(Weight/(Height*Height/100/100),2))>=30,3)))}» in all in one page survey … not the best but it work.


Since it's a LimeSUrvey issue : it must be reported (in my opinion).

Hi
Thank you for your answer

The problem was in formula.

{if(IMC<25,0,if(IMC>=25 and IMC<=30,1,if(IMC>30,3)))}

The last if condition does not have a value when evaluate to false.

If I add a value it works fine with comma as decimal mark.

Any way, I don't need the last if condition.

Thanks