Average Issue

[#1]

Hi,

I have a code which gives me correct stats application by application but when I take average it also counts zero values therefore average decreases than actual should be. How can I resolve this issue either by cod eor presentation?

[#2]

You could try... avg({<Yourfieldname <> 0> Yourfieldname})  and/or make sure suppress zero-values is checked on the Presentation tab.

[#3]

How can ifnore zeros if want to calculate (CMP_Date - pre)

if ( State_Code = 'CMP' , timestamp ( Txn_Date ), null ()) as [CMP_Date]

if ( State_Code = 'CMP' ,( Previous ( CMP_Date )), '' ) as pre