Search results for query: *

Yet another mistake of mine. I changed the summary options of the field to average and the numbers are correct in the crosstab cells. I will have to review the differences in what you have provided with my results. But I do sincerely appreciate the help you have given me!!!

My mistake, the formula is a field I can add to the crosstabs summary. However, when I do insert it, the numbers that appear in the crosstab cells are not the calculated numbers that appear in the amp group details.

I understand now what you were wanting me to try. The calculation for turnaround days per amp is correct based upon the formula you gave me: sum({@Date Diff},{lrunit.cAmpkey})/({#Count of Vacant Units in AMP/Period}) The field is not available to insert into the crosstab to summarize. Is this...

This is what I tried based upon my understanding of what you wanted me to try: sum(({@Date Diff})/({#Count of Vacant Units in AMP/Period})) I received the message ont he formula: A field is required here referring to (({@Date Diff})/({#Count of Vacant Units in AMP/Period})) Perhaps I do not...

My formula: {#Number of Turnover Days/AMP}/{#Count of Vacant Units in AMP/Period} does calculate correctly in the group section. The sum of the trunaround days is based upon the DateDiff ('d',{lrunitst.start_dt},{lrunitst.end_dt}) The turnaround days is not a field in the db/table. I have...

Each AMP is an apartment complex. I am wanting to calculate the average turnaround time for each complex after a apartment in that complex becomes vacant. In some instances, when an apartment becomes vacant, work is done by cleaners, carpenters, plumbers, painters, etc. The work done by each of...

I had done the average date diff for each record, restting on change of amp group and the calculation does not match the manual or calc from summing.

My crosstab has rows which are amps (a group, made up of units) and my columns are month groupings, mar-09, april-09, etc through mar-10. In my report detail I am summing date differences grouped by month (Number of Turnover Days/AMP)and counting each record (Count of Vacant Units in...

I have defined an average formula that gives the correct results in a group footer section of the report. My cross tab is in the reprot footer section of my report. I would like to have that average appear in my cross tab. When I insert the average formula in the cross tab, I get the following...