100% Stacked Bar with Nulls

[joshakehurst]

Hello,

I'm trying to create a 100% stacked bar chart, but eliminate the NULL values from the data set.  I know I can deselect "Show Null Values" from the chart settings, but clicking on the graph still pulls in the nulls into the data set. 

I'm using the following Expression: 

Count(RecordID) / Count(TOTAL <[Agent Name]> RecordID)

[#2]

Could you please post some sample data here..

if I am not wrong

u can try like this   if(not isnull(<[Agent Name]) ,

Count(RecordID) / Count(TOTAL <[Agent Name]> RecordID))