I have a requirement for which I need 12 months average of a particular account at the Year To Date level(Dynamic Calc), also, this would require to skip zeroes or missing values and adjust the denominator to consider only the periods which have values i.e. not missing or 0's.
I tried using the @AVGRANGE function and a @COUNT function, However they do not correctly identify the number of periods with values even though I use the SKIPBOTH parameter.
Any help in the right direction would be greatly appreciated.
Thanks,
Michael