Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Dynamic text box - Measure that returns text doesn't work

Hi,   I have an issue while using dynamic content in a text box.   If I use the Q&A interface to add a dynamic value based on a measure returning a number, everything works fine. If I use the Q&...
Need Help
Prashast's avatar
Prashast
New Member
3 years ago

I was facing the same issue. I changed the data type of my measure to text & it worked. For ex if you change your measure to 

var result = divide(a,b,blank())

return if(isblank(result),"N/A",round(result*100,1) & %)

 

I wanted to show N/A value if result is blank else show the percentage value.