Condition

[narender123]

Hi All,

I have two column

1)Status

2) Paid_Status

i want

If(Status=1,'Approved',

if(Status=2,'Pending',

if(Status=3,'Completed',

if(Status=4,'Paid',

if(Status=1 and Paid_Status=6,'OutStanding'))))) as newstatus,

Result in filter is showing like

Approved

Pending

Completed

Paid

but not shows Outstanding

Why??

I have shown the table box with Status and Paid_Status dimention  in attachment.

Thanks

[narender123]

Thanks you very much but my case it not like your both diemntion .

But its really appreciated.

Through Jonathan Dienst i got my answer.

[narender123]

Thanks Jonathan.its working now.

Thanks to all.