Formula Help
I need help putting a formula together where i would like to divide a given number by the number of details. Can anyone help me find this function / formula? Thanks,
Forum Discussion
This is how i thought it would work as well but i am still getting off the chart numbers when i select Daily output is summarized by "Summed". It seems like the calculation is multiplying on every entry. if i switch the "Summarized By" to Average, then i am closer to the correct output but it is still not quite right. is there a way in the formula to say 240 on a given day or something like that?