5 Replies Latest reply: Oct 1, 2016 9:34 AM by fabio Mazzarelli

# How to exclude null values from a sum?

Hi Community,

How to exclude null values from a sum?

Totale Ore fatturabili = 20.743,95 but I need to exclude (-) values.

The correct value will be 20.743,95 - 4.097,98

Could you suggest a method?

• ###### Re: How to exclude null values from a sum?

May be like this:

Sum({<DimensionName = {'*'}>}Measure)

• ###### Re: How to exclude null values from a sum?

if is have null values in your field , you can remove those in two ways

Way 1(in Dimensions): In your chart , gooto dimension tab , select ur dim and enable supress null option,

Way 2 (By expression) : Sum ({<Dimension Name={'*'}>}Sales)

I hope this may helps you.

-Nagarjun

• ###### Re: How to exclude null values from a sum?

Hi,

My needs is:

i select *  from a database..... example 3 rows

worker, hour

1          10

2          7

3          5

then

using an external .xls file, I create personalized data... example 1 rows

worker name

1     Fabio

All data are joined by the field Workers

Using a pivot tabel, how could exclude rows not in join? 2 e 3

• ###### Re: How to exclude null values from a sum?

Sum({<name = {'*'}>} hour)

• ###### Re: How to exclude null values from a sum?

Hi,

I ASK A LITTLE PATIENCE, probably you're pointing to the solution but I don't understand

Column

TOT

1.508,75

1.484,75

.......

to calculate the values, I use this formula

Sum(DIRFIS)

+ sum({<Commessa = {"=KeepChar(Commessa, '0123456789') * 1 > 10"}>} [TotOreLavorate])

+ sum({<Commessa = {'ASSCLI', 'ASSREM'}>} [TotOreLavorate])

+ sum({<CTRAAN = {'N',""},Commessa = {'ASSTEL'}>} [TotOreLavorate])

+ sum({<CTRAAN = {'T',""},Commessa = {'ASSMOD'}>} [TotOreLavorate])