Forum Discussion
Solved
Multi-level rolling average
Hi everyone, I'm trying to calculate 6 months average amount per financial statement item (FSI), which is basically a multi-level thing (as you have a level Wages for example, and below that leve...
Probably to do with that all(sheet) at the end, see if allexcept(sheet, sheet[FSI]) does anything
jthomson yes, now it works on month and FSI level. but it's not working on Country-level or agregate level yet. Sadly just adding ,"Sheet"[Country_code" to that allexcept formula does not seem to work. suggestions?
Anonymous I'm sorry, I don't understand.
Olia you will need to use allexcept(country code) for that agg as well. I was suggesting using variable to writer cleaner formulas.