Forum Discussion

ADSL's avatar
ADSL
Post Prodigy
3 years ago

Add # to Blank Value

Hi BI Community Team,

 

I hope you're doing well.

 

I have 02 tables -- sales team master & sales order that I am handling a few sales team and not all but sales order table have for all.

 

So then I am doing the sales dashbaord, it is blank as the screenshot below.

 

Any suggestion to add "#" or "Unknown" in the blank?

 

 

Thanks and Regards,

Need Help

2 Replies

  • IoannisPhilip's avatar
    IoannisPhilip
    Advocate III
    3 years ago

    Hi ADSL ,

    You can go to your table editor and click on "Replace Values", there leave the first replace value empty and then input to the "Replace With" sign "#" or whatever you like.

    That should do the trick. I am not sure what the structure of your source tables is, but maybe you need to replace the values there. Let me know if you face any issues.

    Best regards,
    Ioannis

    • ADSL's avatar
      ADSL
      Post Prodigy
      3 years ago

      Hi IoannisPhilip,

       

      Thank you for your feedback.

       

      In Sales Order table, it has a lot of sales rep code and we manage some with master sales rep table have sales rep code, team,..etc.

       

      To Replace Value, we cannot do because it doesn't have blank value.

       

      Any suggestion?