Average Absolute Value

[Giselle100]

Hi,

I am trying to calculate the average of the variable I have created.

vAbsoluteValue = FABS(-(Sum({<[Plan Type Description]=, [SK Plan Type No] = {2}, Year={$(vMaxYear)}>}[Fct Scl Binc Sale Sell Amt]) - Sum({<[Plan Type Description]=, [SK Plan Type No] = {1}, Year={$(vMaxYear)}>}[Fct Scl Binc Sale Sell Amt]))
/
Sum({<[Plan Type Description]=, [SK Plan Type No] = {2}, Year={$(vMaxYear)}>}[Fct Scl Binc Sale Sell Amt]))

Average Value =Avg($(vAbsoluteValue)) is returning a zero value

Please assist

Thanks.