Forum Discussion

StLaurie's avatar
StLaurie
2 years ago

Remove NaN from Dynamic Table Widget

I have a dynamic table with top 10 resources displaying a certain datasource and of the 100 resources and their instances at any point in time there may only be 1-5 items that have any data, otherwise the datasource returns No Data, however the widget displays NaN against that same instance.

Is there a way to remove NaN from the table using the Dynamic (Top10) list?
I am currently using the following expression to turn NaN into 0:  

if(un(AllFilesOldestInMin),0,(AllFilesOldestInMin))

 

Cheers!