Sum of Null shows zero value

[Anonymous]

Hi all,

I'm trying to show a straight table with blank value when no value exists,

I prefer not to add If's to the UI since speed is an issue here.

I have NULL values in the second column (i.e. NumOfApps),

but when I sum it in straight table i get zero !

Can anyone explain:

1. why this is happening?

2. a way around this

Thank You,

Nir Katz

[sunny_talwar · Accepted solution]

A way around this would be something like this;

If(Len(Trim(Avg(NumOfApps))) > 0, Sum(NumOfApps))

Update: I just realized that you did not want wish to add an if statement.... May be give this a try:

Avg(NumOfApps) * Count(NumOfApps)

[sunny_talwar]

Sample attached: