So it's acting that way because of the Number of Records you have based on your blend. I too have been plagued with this. For my case I went back and fixed my import so I wasn't blending, but in your case I think you can just divide ARPU by SUM([Number of Records]) to get the average you want.
Am I off base?
ARPU calculation_kp.twbx.zip 122.9 KB
1 of 1 people found this helpful
Thanks Kyle, that's great!
Are you able to help me get the total average base?
thanks - I've updated my average base formula to
WINDOW_AVG(SUM([Closing Base]), -1, 0)
& the overall total works now
Good to know your get your problem solved.
Katherine: Please mark your question "assumed answered" or otherwise mark it answered so others know not to try and help with this thread. Helps keep the forum clean. Thanks!