6 Replies Latest reply: Feb 28, 2012 4:48 AM by Iyyappan V RSS

How to sum(amount) except null?

Bill Ringer Salalima

I have data sample below:

 

Region
Amount
Region A5000
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