Null() issue?

[#1]

I have source application and target appliaction.while testing two applications the avg(Sal) is not coming correctly.

assume that in target some null values added extra compare to source.

so it will take avg means all the count of null values right?

how can i achieve it?

both sum(sal) is same value in source app and target app.

but Avg(sal) is not correct.

[tresesco]

Avg() disregards null values. You have alternative to use to include them, try your own formula for the same like:

Sum(Amt)/ Count (yourDim)

[chrislofthouse]

Is this in the script or in a chart in the dashboard?

[#4]

Hi,

In straight table i am using this expression like avg(Sal)

how cani achieve this if i have null values.the avg vl count the null value count also so

[chrislofthouse]

Are you positive it is nulls creeping into the calculation and not zero values, it would make more sense if it was the latter?

[awhitfield]

Hi Rakesh,

please see the attached example, is this what you require?

Andy