Trouble filtering out nulls in chart w/ two expressions

[#1]

I have a chart with a few dimensions and two expressions.

My first expression is a count using set analysis to modify the set it is called [OPEN ACTIONS]:

if(([AM Impact]= 'P1/S1' or  [AM Impact]= 'P1/S2' or [AM Impact]= 'P1/S3'),Count({$<Status={'Open','Reopened'},Age={'>=28'}>} [Action Item ID]),

if([AM Impact]= 'P2',Count({$<Status={'Open','Reopened'}, [AM Impact]={'P2'}, Age={'>=56'}>} [Action Item ID])))

My Second expression is Concatenating one of my dimensions (Impacted Application) into one value, separated by commas:

concat(DISTINCT [Impacted Application],', ')

The problem I am having is I have null values in my OPEN ACTIONS expression in the chart and I need these to be filtered out of the list:

I tried adding an if statement to the second expression mentioned above:

=IF([OPEN ACTIONS]>0, concat(DISTINCT [Impacted Application],', '), Null())

But QV tells me there are errors in the expression.

Anyone have ideas on how to solve this?

Thanks,

J

[swuehl]

Try

=IF(Column(1) >0, concat(DISTINCT [Impacted Application],', '), Null())

if your open actions expression is the first expression column in your chart.

[sunny_talwar]

Are you checking for Nulls or 0s?

May be this:

If(Len(Trim([OPEN ACTIONS])) > 0, Concat(DISTINCT [Impacted Application], ', '))

[#4]

Use If( len(Open ACTIONS) >0, -----