Thanks in Advance,
i have a requirement as follows and i need to calculate Average from the same.
March 2016 0
i have value for 9 Months including 0 and 3 months is Blank, my average need to be calculated as BIAS / 9(should be Dynamic), so i have created a Count(Formula variable) for BIAS where i have mentioned the Formula as (BIAS >= 0) * 1 + 0. ie if BIAS >= 0 then 1 else 0, with this count value i thought of taking the average calculation but the formula didn't work, it takes both 0 and Blank as same.
Please help me with a solution for the same. Hope i made my requirement clear.