I have a formula that at first glance I thought would be simple to do as an expression:
Take a range of days for two fields and multiply their values for each day. Then add each of those values to the other days. Finally, divide by the sum value of one of the fields.
4/1/12 - [numItems] = 5; [numBuys] = 3
4/2/12 - [numItems] = 7; [numBuys] = 4
Sum Total of "numItems" = 12
Formula = ((5*3)+(7*4))/12 = 3.5833
My problem is that because the user can have a date range, I am unsure how to address this. I was thinking that VBA may be better...?
Any help would be appreciated. Thank you.