Need Help in if condition(Calculated Dimension)....??

[dhasharadh]

Hi All.

1. if division is Excutive then we have to disply EC name as  CEO.

2. if EC name is null then -- we have to display EC name as Visitors/Others.

can any correct the below condition which we are using as a calculated dimension please as per the above seanario...

if(ISNULL[EC Name]= 'Visitors/Others',(if(Division) = ‘Executive’, CEO))

EC Name is 'N/A'  so we are considering it as NULL..

[olivierrobin]

if(division='Executive',

CEO,

if(len(trim([EC Name])=0 or [Ec Name]='N/A',

'Visitors/Others',

[EC Name]

)

)

[dhasharadh]

Thanks Robin,

But getting syntax error.

if(division='Executive','CEO',if(len(trim([EC Name])=0 or [Ec Name]='N/A','Visitors/Others',[EC Name])))

i have verified couple of times all braces are closed properly, No idea why am getting that.

[olivierrobin]

right parenthesis missing in len(trim( ......

and the last one is to be suppressed

if(division='Executive','CEO',if(len(trim([EC Name]))=0 or [Ec Name]='N/A','Visitors/Others',[EC Name]))

[dhasharadh]

Thanks again, but still getting some counts under null category.

we want those counts as well under 'Visitors/Others' only. Can you change the expression please.

[olivierrobin]

you have to check the values of Ec Name concerned so you can add the needed condition in the statement

[vishsaggi]

Can you show use the list of values coming from your field EC Name?