Expression

[nareshthavidishetty]

Hi,

We have an application it re-direct to the different web page.Here i have used the logic [Report Name] &'<URL>'&[Wiki Link] but for some reports the there is no link (N/A).

I need to show the reports which doesn't have links as N/A.

Please find the attached QVW and spreadsheet for reference.I the below image i need to replace the marked as N/A.

Thanks..

[kaushiknsolanki · Accepted solution]

Hi,

Try this expression.

If(WildMatch(link,'N/A'),link,[Report]&'<URL>'&[link])

Regards,

Kaushik Solanki

[zhadrakas]

try this Expression:

if([link]='N/A', 'N/A', [Report] &'<URL>'&[link])

[nareshthavidishetty]

Thanks..Now i need to include two status as 'Pending' and 'N/A'.

[kaushiknsolanki]

Use the same logic.

Regards,

Kaushik Solanki