Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
If( only({Comp1} Residency) ='Overseas',1,0)
If( only({Comp1} Residency) ='Overseas',1,0)