I have a table and I need to build a Virtual column with averages. I need an average of column [DSO] based on two things:
Date [year] = "Current year" ( I already have a virtual column "year")
Branch [branch] (I have 7 different branches PLUS my "Total" = so It will calculate 8 Averaged DSO)
TABLE:
[Key] [Date] [Branch] [DSO]
SNIPPET OF DATA/TABLE:
Solved! Go to Solution.
User | Count |
---|---|
15 | |
11 | |
9 | |
8 | |
4 |