Calculated dimension: Nested IF returns a null value in addition to the other correct value

[#1]

Hi,

I have the following calculated dimension:

=If(GetFieldSelections(Language_Id) = 'FR', REV_SubRubric_FR, (If(GetFieldSelections(Language_Id) = 'DE', REV_SubRubric_DE,(If(GetFieldSelections(Language_Id) = 'EN', REV_SubRubric)))))

here isthe tables relationship:

I have only 6 rows on the FieldsMap1 table.

Can someone explain me why I got 7 values in my calculated dimension?here is the chart where you can see a null value:

If, instead of a calculated dimension, I use the Field REV_SubRubric as my dimension, then I got only the 6 correct values.

Do you know what I am doing wrong?

thanks,

Caro.

[Stefan_Walther]

Sorry, I think without any sample data this question is really hard to answer 🙂

[#3]

Hi there, try this:

pick(match(Language_Id,'FR','DE','EN'), REV_SubRubric_FR, REV_SubRubric_DE, REV_SubRubric)

Regards

[johnw]

Oh, and in addition to simplifying with the pick(match()) that Ivan gave, checkmark "suppress when value is null" for your calculated dimension. That should make the null value go away.

[#5]

Thanks for the solution !! Works fin for me too

Gracias por la solcion !! A mi tambien me funciono