IF in Expressions

[bsbernabe]

Hello There,

I have concern regarding the expression, i' m trying to  get the value of FINAL_CLASS just happen sometimes is not available so if not i need to get the INITIAL_CLASS  i composed like this:

=if ([FINAL_CLASS] = ' ',INITIAL_CLASS,FINAL_CLASS)  but the problem is only INITIAL_CLASS appear although the FINAL_CLASS value is available.

Sample Data:

INITIAL_CLASS    FINAL_CLASS

    A                                 A

    B                                 B

    C                                 C

    D                                 D

    E                                 E

    F                                 F

screenshot below:

Best Regards,

Bing

[Chanty4u · Accepted solution]

try below

=if (isnull([FINAL_CLASS]),INITIAL_CLASS,FINAL_CLASS)

[Anil_Babu_Samineni]

We can do number of days for this? Can you share exactly data set with some null values?

[bsbernabe]

Hi Chanty,

Thank you for your support.

Best Regards,

Bing

[Chanty4u]

cool

[bsbernabe]

Hi Chanty,,

  Your expressions is working base on my sample data but i observed one thing that if the FINAL_CLASS is empty it is not working supposed to be if the FINAL_CLASS is empty get the value of INITIAL_CLASS. is it possible? although it is another scenario but I'm just asking. sorry so late reply about this concern. hoping you can help me about this.

Sample Data:

INITIAL_CLASS    FINAL_CLASS

    A                               

    B                               

    C                                 C

    D                               

    E                                 E

    F                                 F

Best Regard,

Bing