1

String Display

Hi Pyramid Community,

I'm facing an issue in displaying string in dynamic text. Please refer to the snips to understand my issue:

1. This is the formula I have on Formulate: It returns "N/A" string if measure is 0

2. This is the column in dynamic text matrix grid:

 3.  And the formula I have:

 4. but when I test it, it returns a blank result instead of "N/A" string as shown below:

 Could you help me with this issue I'm facing? I want the "N/A" string to be displayed on running data(0,3).

 

Thanks & Regards,

Sanjai

4 replies

null
    • Senior Director of Product
    • Ian_Macdonald
    • 3 wk ago
    • Reported - view

    Hi 

    Try FormatteData(0,3) instead.

    Hope that helps.

    Ian

      • Sanjai
      • 3 wk ago
      • Reported - view

       Thanks for the reply. Using FormatteData(0,3), I'm getting a syntax error:

      • Senior Director of Product
      • Ian_Macdonald
      • 3 wk ago
      • Reported - view

       Sorry, I missed a "d" in the function name. It should be FormattedData(0,3)

      If you right click on the cell in question, you can pick the function off the list.

      • Sanjai
      • 3 wk ago
      • Reported - view

      Thanks a lot. This helped

Login to reply

Content aside

  • Status Answered
  • 1 Likes
  • 3 wk agoLast active
  • 4Replies
  • 27Views
  • 2 Following