Forum Discussion
Solved
Calculating a weighted average if date within range
Hi, My Employer has asked me to calculate e "weighted average days" from invoices. I assume that I would need to build a formula on the following logic Sumproduct(Amount * Days(outstanding)/T...
Hi， Telli
If your problem has been solved, you could accept the helpful answer as solution to close this thread.
Other community members will easily find the solution when they get the same issue.
If you haven't, please feel free to ask.
Best Regards,
Community Support Team _ Eason
Much appriciated amitchandak. Will try it during the weekend
v-easonf-msft
Community Support
Community SupportHi， Telli
If your problem has been solved, you could accept the helpful answer as solution to close this thread.
Other community members will easily find the solution when they get the same issue.
If you haven't, please feel free to ask.
Best Regards,
Community Support Team _ Eason