Forum Discussion

Gelain's avatar
Gelain
Frequent Visitor
9 years ago
Solved

Column calculated with IF

Hi! 

 

Table A: szatendimento

datasaida

statusconta

30/05/2017

NULL

30/05/2017

C

 

I need to create a calculated column where:

 

If the datasaida column is filled and the account status is different from C, generate the letter F, otherwise generate the letter A.

 

I did so:

 

StatusF = IF (SZATENDIMENTO[DATASAIDA] <> BLANK (); "F"; "A")

 

I could not include the condition "and other than C".

 

I ask for help!

 

Thank you.

  • Gelain

     

    StatusF = IF (SZATENDIMENTO[DATASAIDA] <> BLANK () && SZATENDIMENTO[STATUSCONTA]<>"C"; "F"; "A")

2 Replies