Add expression only when other expression exists

[#1]

Hi!

I've created a straight table with a number of dimension and one expression. I now wan't to add a second expression (or dimension) which should be visible only when the furstexpression has a value in that column. If I add this dimension as a dimension or an expression, it is going to att rows to the table where the first expression has no value.

A little illustration.

Before:

Product	Category	Sum(sales)
shirt	clothes	50
bag	accessories	100
pants	clothes	75
shorts	clothes	30
jacket	outerwear	80

After:

Product	Category	quantity	Sum(sales)
shirt	clothes	5	50
bag	accessories	1	100
pants	clothes	5	75
shorts	clothes	3	30
jacket	outerwear	1	80
hat	accessories	4
shoes	shoes	7

So Sum(Sales) is my first expression and quantity is my second. I don't want to show the rows where Sum(sales) is null. Is there an easy way to do this?

[shree909]

Hi ,

  this can be done by writing an isnull operation for quantiry, if(isnull(sum(sales) = not null,quantity)

try this

[jeffmartins]

Hi kimlindell,

You can use quantity expression as if(sum(sales) > 0 ,sum(quantity))

See the attached file

Regards