Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Stefen please explain what you want by this expression
In my formula value2 should have b or c.
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
Try something like:
sum ( { <value1 = { 'a' }, value2 = { " $(=if (value3 = 2,'b','c')) "} >} eur)
Hi Stefan
evaluate if( value3 = 2, 'b', 'c') in a variable let say x.
now try this
Sum({< value1 = {'a'}, value2 = {$(x)} >} eur)