Search results for query: *

Thank you very much. Everything is working fine. As I told you I tried a few different solutions and one of them was very similar to the right one, but I didn't get the problem with running totals. Thank you again.

I'm outside office today so I cannot check, but it seems you are right and I'm stupid :) It happens. What shall I do after grouping?

The same order (same order#) may have different codes with different amounts Here is the example: 1st january; order #1; code xxx; amount 100 1st january; order #1; code yyy; amount 100 1st january; order #2; code xxx; amount 200 3rd january; order #3; code xxx; amount 50 5th january; order #4...

Sorry, I guess I didn't explain well. I want the average amount for each code each day and the amount std dev (daily).Example: 1st january; order #1; code xxx; amount 100 1st january; order #2; code xxx; amount 200 3rd january; order #3; code xxx; amount 50 7th january; order #4; code xxx...

The std dev formula is: sqrt((n * sum[sq(x)-sq(sum(x))])/sq(n)) with: sq = square sqrt = squareroot

I have a table with the following fields: 1. order date 2. order number 3. code ordered 4. order amount What I want is the average and the daily standard deviation for every different code. I grouped data for {order date} and then for {code ordered}. For the daily amount I did: sum ({order...

No problem for the formula, I just wanted something easier. Thank you

User should determine the date range, through our information system, but I can even use something like "last six months", which is easier. The problem of doing it manually is not the average, is the standard deviation. I'll try, but I'm not sure. Thank you very much.

Hi all, I'm trying to make a complete analysis of order amounts in the last X months. I have a table with: 1)order number; 2) order date; 3)code; 4) amount; 5) customer. What I need is: a) daily amount average for each code; b) standard deviation for each code; c) number of customers for each...