Multiple if conditions.

[yogitamehta10]

Hi All,

I'm using a table chart, In one of the dimension i have show value of STATUS .

Status has two values Open CLoSED, i want Open to shw when  Flag=1 , for closed i have no condition .  flag is another field in  data  it has 1 and 0 value.

Any solution ????

[sunny_talwar]

May be this:

If(Status = 'Open', If(Flag = 1, Status), Status)