if...else in formula

[Anonymous]

Hi,

is it's possible to use if...else in formula?

sum ( { <value1= { 'a' }, value2 = { 'b' }>} eur)

sum ( { <value1 = { 'a' }, value2 = { if (value3 = 2,'b','c' } >)

Regards

Stefan

[sujeetsingh]

Stefen please explain what you want by this expression

[Anonymous]

In my formula value2 should have b or c.

[#4]

hi Stefan,

i don't think that if...else can use internal set analisis,

if...else  is an alternative the set analisis:

sum(if...)

Regards

[tresB]

Try something like:

sum ( { <value1 = { 'a' }, value2 = { " $(=if (value3 = 2,'b','c')) "} >} eur)

[senpradip007]

Hi Stefan

evaluate if( value3 = 2, 'b', 'c') in a variable let say x.

now try this

Sum({< value1 = {'a'}, value2 = {$(x)} >} eur)