Forum Discussion
Average Per Store on Weekly Data
Hello, My datasource is enormous where i use CSV file as main file. I have nearly 300+ store list where i have the weekly and daily average percentage value. I need a help on caculating the averag...
Thank you for the report.
In the report,
1) if i select Store - 000 and HHH, the average should be 18%.
2) If i select store - TTT and NNN, the average should be 32.5%.
3) The overall % of the store should be(36%+40%+25%+20%)/6 (Total stores = 6), hence the ans should be 20.16.
Hope this can help.
Sorry, I cannot agree with that methodology. I hope someone else can help you further.