I found the problem, it was on the report. I had the field set to return the first record. It works now. Thanks for your help!
1 Like
Sorry to bring up an old post, but is anyone aware of how to get the last 24 months in a similar format? Thanks for this great BAQ for 12 month usage and it will definetely help, but we would like to pull the STDEV of the last 24 months of usage in order to calculate our minimum. Since this is using months 1-12 we would obviously have overlapping months of the two years. To differentiate them we could look at the year and the month but we obviously want to avoid hard coding the years into the BAQ as this would not be able to be used year to year. Is there another way of going about this?