How to sum(amount) except null?

[#1]

I have data sample below:

Region	Amount
Region A	5000
Region B	4000
	3000

I want to sum up all amount excluding the Region which is NULL or no region. Now, this is simple when manipulating the table properties. But this time, I want to sum it up through set analysis... So is it possible to sum(amount) except Null Region?

This is my idea, something like this: sum({<Region is not Null>} Amount)

Please help me get over this, thanks. Coz I want it to display in the dashboard, and displaying data in the dashboad includes null values. Which is DUH!

Thanks.

Best Regards,

Bill

[vijay_iitkgp]

Hi ,

You can use Sum(Amount) only and Go to Properties--->Dimension and check Supress when value is null.

Hope this will help you.

[v_iyyappan]

Hi,

     use the expression like this

     =if(IsNull( Region),sum( Amount))

regards,

Iyyappan

[CELAMBARASAN]

Hi,

     Try using this.

     =sum({<Region={'*'}>} Amount)

It won't consider null values.

Celambarasan

[SunilChauhan]

try this

sum({<Region-={}>} Amount)

may show red line but it will run

hope this helps

[jagan]

Hi,

Use this expression

=Sum(If(Not IsNull(Region), Amount))

Hope this helps you.

Regards,

Jagan.

[v_iyyappan]

Hi,

     cau u attach a sample file.

Iyyappan

[cavmih18]

This helped me with a similar problem. Thanks. Well appreciated.