[In Oracle, the SUM returns the sum of values of expr.] [In Oracle, the NULLIF function compares expr1 and expr2. If expr1 and expr2 are equal, the NULLIF function returns NULL. Otherwise, it returns expr1.]
As you see above, QAGO has shifted the values by 1 quarter,
and AGO has shifted the values by 1 year - Ago(sum(fo.sum_1), [Level Year], 1)
I am thinking I might have to do something in the script or am I wrong?