1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Daily Average from Continuous Monthly Totals

Working with employee productivity and they are required to perform to specific requirements. I am looking to bring our reporting into this century.

I have monthly totals that update every month and I want a daily average to adjust as the months are added not by 12 months from day 1.

I'm actually in need for a couple different formulas. Percentage of denied and approved refunds and the daily average. Remember all totals will go up every month when those are added. I tried the percentage formula but was not getting the right number and 2 zeros were added and could not remove them with the decrease decimal option.

Any help or suggestions are welcome and appreciated.

submitted by /u/Babe223377Jess
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#financial modeling with spreadsheets
#rows.com
#natural language processing for spreadsheets
#AI formula generation techniques
#generative AI for data analysis
#Excel compatibility
#formula generator
#Excel alternatives
#daily average
#monthly totals
#employee productivity
#reporting
#formulas
#percentage
#denied refunds
#approved refunds
#adjust
#totals
#update