Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be this
Sum(sal)/Count(sal)
Or
Sum(sal)/Count(DISTINCT Dimension)
Where Dimension is the field you are trying to average sal
Try like:
Sum(Sales)/(Count({<Date={'<=$(vMaxDate)'},Sales-={""}>} Sales))
Check the dates also.