thanks, it works but can you please explain why simple addition was not working for calculation 3 whereas subtraction was working fine for the Z Test Numerator.
The reason is at row level, when it is identified as current quarter, it can be previous quarter as well, so previous quarter in this row will be null. but you just need the aggregation, so I add zn() to convert null to 0.
Hope this make sense
calculation3 is working fine by using ZN() but the final goal of calculating the Ztest value is still not accomplished.
the "Z Test value" is still not showing anything and if I use ZN(Z test Value) it returns zero.
i tried calculating the Sqrt(calculation 3) first, which again is giving me unexpected results, Sqrt(6.3) is giving 3.5 as a result which is wrong.
can you tell me what is wrong with the calculations.