Null() function

[Anonymous]

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.

[sunny_talwar]

May be this

Sum(sal)/Count(sal)

[sunny_talwar]

Or

Sum(sal)/Count(DISTINCT Dimension)

Where Dimension is the field you are trying to average sal

[balabhaskarqlik]

Try like:

Sum(Sales)/(Count({<Date={'<=$(vMaxDate)'},Sales-={""}>}  Sales))

Check the dates also.