Filter in Webi Report.

Hi Experts,

When I am trying to filter the table with "Total Value Final" not Equal to Zero, all the measures would become #UNAVAILABLE.

Withou Filter

with Filter on Total Variance Final <> 0

Formula written for Total Variance Final = If ( Userentry <= TotalVarainace Final ) then TotalVariance Final.

Please note - User entry is prompt in the report.

Please advise.

Thanks.