Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Please find the attached file.
I want to show the Average is calculating as below,
if(1 st column is getting same value as in the Average Month, else getting rangeAvg from Jan to Jun2018
Next
Jul2018 is getting same value as in the Average Month, else getting RangeAvg from Jul to Dec2018 )
expecting Output:
Default_YearMonth | Jan2018 | Feb2018 | Mar2018 | Apr2018 | May2018 | Jun2018 | Jul2018 | Aug2018 | Sep2018 | Oct2018 |
Average | 9.4% | 10.0% | 10.0% | 10.4% | 10.5% | 10.3% | 7.6% | 8.7% | 9.8% | 10.7% |
Red | 16 | 18 | 17 | 19 | 18 | 16 | 14 | 18 | 22 | 25 |
Total | 171 | 169 | 169 | 165 | 166 | 175 | 184 | 184 | 183 | 189 |
Average Month | 9.4% | 10.7% | 10.1% | 11.5% | 10.8% | 9.1% | 7.6% | 9.8% | 12.0% | 13.2% |
I am using in the below expression and getting incorrect RangeAvg
=RangeAvg(Before(RangeSum(Average Month),0,6))
Please help me on it.
Thanks & Regards,
Vidhya K
May be you need this
=RangeAvg(Before(Sum(Average_Month), 0, 6))