WEB URL is not working with blanks

[TcT85]

Hi,

I have setup a WEB URL under PCO column, it works when there is a date in Assign dates, but when there is no date in followup_start_date the URL link is not working. 

PCO Item URL = "http://webpage/#/pct/pco/" & 'PCT_PCO'[PCOID]

I used conditional format to display the missing dates.

TABLE 1 just contain 2 columns 1 is PCO ID and second column is Product name

TABLE 2 only contains data where there is a date.

How can I show the WEB URL under PCO ID when there are no dates for this PCO ID?

[PhilipTreacy]

Hi @TcT85 

Hard to understand what you are doing as you haven't provided any code except this

PCO Item URL = "http://webpage/#/pct/pco/" & 'PCT_PCO'[PCOID]

If you are building the URL with that code then I don't see how the date column comes into it.

Can you please provide your file so I can examine your code.

regards

Phil