If else condition for below business condition

[Anonymous]

Hi

I have a business requirement in which

If primaryobjective ='Profitability' then it has to through 'Revenue' & 'Pipeline'.

So how to achieve this by If else condition

Thanks

Surya J

[dapostolopoylos]

If i got it right you need something like that:

if(condition1='Revenue',

     if(condition2='Pipeline','Profitability','Other'),

     'Other')

[Anonymous]

Hi Dimi

Tanq for your response

I am trying to achieve the below

=if(primaryobjective ='Profitability','Revenue',

if(primaryobjective='Profitability','Pipeline',

if(primaryobjective='Revenue','Pipeline',

if(primaryobjective='Revenue','Profitability',

if(primaryobjective='Pipeline','Revenue',

if(primaryobjective='Pipeline','Profitability',

primaryobjective))))))

I have added this condition in filter its providing single option for Profitability ,Revenue & Pipeline also.

But It has to single to many.

Can you please suggest?

[dapostolopoylos]

Your statement doesn't look right to me...

For what kind of business logic you are double checking each individual value of primaryobjective?

Explain what do you want to achieve and why, in order to have a suggestion i must understand whata are you doing