0

How to get text output from dynamic text?

Hello,

I'm trying to create a dynamic text that would produce a different text output based on the country that the publication is scheduled for. I can get this to work with numeral outputs like this:

if(label(1,1,0)=="Germany",1,0)

of

iff(label(1,1,0)=="Germany",1,0)

but I have not been able to generate a text output. In BI Office it works like this: iff(label(1,1,0)=="Germany","text here","other text here") but in P2018 I only get errors.

Br,

Simo

3 replies

null
    • Senior Director of Product
    • Ian_Macdonald
    • 6 yrs ago
    • Reported - view

    Hi Simo,

    Seems to work for me. See image below.

    Hope that helps.

    Ian 

    • Nikos_Volakakis.1
    • 6 yrs ago
    • Reported - view

    Hi Simo

     

    when you select the desired field and press test do you see the name or Null value? 

    I had the same problem and saw only null values for strings so I created a custom member with numbers and solved it

     

    Nikos

    • SimoLeppanen
    • 6 yrs ago
    • Reported - view

    Thanks for the help guys. It seems to work now, it looks like I might have had a linking problem in the data model that was causing the issue.

    Br,

    Simo

Content aside

  • Status Answered
  • 6 yrs agoLast active
  • 3Replies
  • 58Views
  • 3 Following