if condition

[raadwiptec]

is it possible to have like an if condition as below

if(match(country name, then A and B else C

A

B

C  are 3 different values in one table.

[YoussefBelloum]

Hi,

you want to do it on the script or on the charts ?

and A, B and C are values or fields ?

[Chanty4u]

try this

=PICK(Match(CountryName, 'A','B','C') 'A','B','C')

[raadwiptec]

it should be in the script only..

[Anil_Babu_Samineni]

Chanty, What is the use of this? I believe this returns same as from Field

[Anil_Babu_Samineni]

What you want to do so in script?

[sunny_talwar]

[sunny_talwar]

Would you be able to elaborate your requirement with an example?

[raadwiptec]

hi all,

I need to hard coded values

is it possible to have like an if condition as below

if(match(country name, France then 'Legal' ,'processed' else 'unauthorized'

The above is working only  for one output ex: legal. i require both..

Legal

processed

unauthorized

are 3 different hard coded values in one table. so when i select country --france in the report in another list box i should see below as 2 different values as because in the data model the below 2 value exists in another linked way

legal

processed.

[Anil_Babu_Samineni]

on what bases you want to pick one another one? Could u describe more