2 Replies Latest reply: Jan 23, 2017 10:16 AM by Nicolò Cogno RSS

    If statement in filter

    Nicolò Cogno

      Hi everybody,

      I've got two tables like these:

       

      Table A

      VALUES     DESCRIPTIONS

      value1        descriptionA;

      value2        descriptionB;

      value3        descriptionC;

       

      Table B    

      VALUES     DESCRIPTIONS

      value1        descriptionD;

      value3        descriptionE;

       

      I would like to have the description contained in Table B if there's the code in it and if not I'd like to have the description contained in Table A. To do that I used this statement:

      If(IsNull(TABLE B.DESCRIPTIONS),TABLE A.DESCRIPTIONS, TABLE B.DESCRIPTIONS)

       

      If I use that statement in a tree map chart I get what I want, but if I use it in a filter (in order to filter my fields by the description) I only get a blank list.

       

      What should I do?

       

      Thanks a lot in advance !!!