Average Absolute Value

Giselle100 — Sat, 16 Nov 2024 06:22:23 GMT

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.

topic Average Absolute Value in App Development

Average Absolute Value