Hi All
I have 2 columns:number of month and revenue. Need to create 3rd column where to show average revenue for last 2 months.
For example
N Rev AvR
1 2 -
2 4 -
3 6 3
4 8 5
and so on
Could you please advise whats the easiest way to do this? I can split it manually and then count sum and then union again, but for sure there should be faster way.
Thanks in advance.
Solved! Go to Solution.
One option is to use the Multi-Row Formula tool, with:
- Num Rows set to 2
- Value for Rows that don's Exist set to NULL
- Expression: ([Row-2:Rev]+[Row-1:Rev])/2
- You can also use the Group By to partition, or restart.
The combination of using addition and NULL config result in a Null value when there are not two prior records.
God bless you! That worked!