Use more Arguments in Image Condition (Formula)

[Former Member]

Hi all,

i want to use more than one argument to define in a condition whether a image is shown or not.

I used following two possibilities, but nothing worked. The VC takes only the first

argument but not the second. FYI: @Abweichung_calc_proz is TEXTFIELD

BOOL(IF(NSTR(@Abweichung_calc_proz,'.2')>=0,(IF(NSTR(@Abweichung_calc_proz,'.2')<=20,true,false)),false))

BOOL(IF(@Abweichung_calc_proz<=20 AND @Abweichung_calc_proz>=0, true, false))

Thanks for any help, best regards

Frank

[Former Member · Accepted solution]

Try this:

BOOL(IF((@Abweichung_calc_proz<=20) AND (@Abweichung_calc_proz>=0), true, false))

or this

BOOL(IF(bool((@Abweichung_calc_proz<=20) AND (@Abweichung_calc_proz>=0)), true, false))

Best Regards,

Marcel

[Former Member · Accepted solution]

Hi Marcel,

BOOL(IF((@Abweichung_calc_proz<=20) AND (@Abweichung_calc_proz>=0), true, false))

Is not working either. Maybe theres another Problem???

Field Abweichung_calc_proz is also calculated in the table. Can i be sure that

Abweichung_calc_proz is calculated before i make my check on the other field?

The other thing: Abweichung_calc_proz is a "text"-field.

Thanks,

Frank

[Former Member · Accepted solution]

Hi,

You forgot to typecast the textfield in IF.

Try

<b>BOOL(IF(INT(@Abweichung_calc_proz ) <=20 AND INT(@Abweichung_calc_proz )>0,true,false))</b>

It will work

Regards,

Sooraj

[Former Member · Accepted solution]

Hi Frank,

ok then it's clear why this doesn't work. You have to cast the values as Sooraj mentioned.

You must care to the datatype.

Best Regards,

Marcel

[Former Member · Accepted solution]

Problem solved. Thanks to you all !!!

[Former Member]

Hi Frank ,

Make use of Comparion methods, and the Logical operators ( OR,AND) to suffice your need . I have implemented similar kind of thing using those operator and it worked fine .Try not using IF .

Thanx

Pankaj

[Former Member]

You need to nest the arguments.

[Former Member]

Hi Mario,

how can i do that?

Best regards,

Frank