calc condition using field in an alternate state

[hopkinsc]

Hi all,

I have a pie chart that i am trying to set up a calculated condition on..

I dont want it to calculate if a selection on 'Residency' ='Overseas' so i have done the following..

If(Residency='Overseas',1,0)

this works as expected, but the field 'Residency' needs to be in an alternate state (Comp1). how can i add this into the if statement?

Thanks

[swuehl · Accepted solution]

If( only({Comp1} Residency) ='Overseas',1,0)

[sibideepak]

HI hopkinsc,

try ,

if([Comp1]Residency='Overseas',1,0)

or

try

as swuehl told

If( only([Comp1] Residency) ='Overseas',1,0)