Forum Discussion

Rena's avatar
Rena
Resolver II
8 months ago
Solved

Error on a Switch Function that makes no sense

So I have a Switch Function that builds a display box.

It makes this:

 

The problem is that I want to change the words in Row 5 to "Total # Tagged DT Events".  Sounds simple.  I change the measure to this:

But my table deletes the value rather than adding the word "tagged":

 

 

  • Never mind.  The answer was in the question itself.  It is a switch true.  When I change the word, the value was deleting because the words no longer matched my table.  It has been too long since I created that, I didn't realize it was looking at a table and giving a value based on if it matched the table.  I had to go into Transform Data and edit the table that was originally created.

3 Replies

  • Rena's avatar
    Rena
    Resolver II

    Never mind.  The answer was in the question itself.  It is a switch true.  When I change the word, the value was deleting because the words no longer matched my table.  It has been too long since I created that, I didn't realize it was looking at a table and giving a value based on if it matched the table.  I had to go into Transform Data and edit the table that was originally created.

  • Hi Rena 

     

     This could be a caching issue rather than the measure. Try creating a new measure as a first step in fault finding.

    • Rena's avatar
      Rena
      Resolver II

      Creating a new measure is what made me realize I was saying if you see "Total # DT Events", then put the measure.  Not that I was telling the table which words to put.