var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Please see the .pdf attachment.
The above formula is correct for all of the calculations except the three noted on the attachment.
They are the correct field names. (Not as shown on the field labels at the top of the report.)
Why would it fail on these three?
Thanks . . . Rick
I notice all of the numbers that are incorrect where for sections that had more than one listing. I also noticed you're not using aggregate functions in your formula. What does [ClosePrice] and [ListPrice] refer to when you have multiple listings?
Hi Teddy - after studying that again I figured it had something to do with multiples in the averages.
Aggregate functions in my formula?
Aggregate usage is something I've not been able to get a hand on in Access. Never!
How does that apply here in the formula?
Would it be something like . . . =((AVG[ClosePrice])-([AVGListPrice]))/([AVGListPrice]))) ?
Oh by the way - these fields under a group footer.
[ClosePrice] and [ListPrice] are fields in a table. the closed price is what the property sold for. The list price is the current asking price.
Yup, if you intend to operate on averages then you need to explicitly tell Access that you would like to operate on them. Otherwise why wouldn't it choose sum, or count? When you don't specify an aggregate function like that, Access will assume you intended to operate on the last record of the group. If you run your formula against the list and sale prices of the very least record of each group, you'll see what I mean.
Calculation Formula Reslults ? ? ?
Please See Attached.
The results from this formula are a set of numbers ########%, eight numbers ending with a percent sign.
The numbers do not reflect what the correct answer should be.
I'm looking for ##.##% or -##.##%
There are no errors flagged with the formula.
The percent format operates on the assumption that the number 1 means 100%.
What number are you coming up with before applying the "Percent" format?
See Attachment for Results.
You fed the average asking price into the formula and formatted as a percentage.
Those are all your average asking price multiplied by 100, which is what formatting as percentage is supposed to do.
Have you ever used excel, by chance?
Last edited by Teddy; 05-14-10 at
Excel. . .
I have that formula everywhere in Excel and it works flawlessly.
Example . . .
What formula did you end up plugging in to Access that effectively gave you =B10?
Excel 2003 Example
This is Excel's formula that accomplishes the same thing which is then formatted as a percentage.
Any ideas how this can be applied to Access 2003?
Thanks . . . Rick
Still Fighting Percent Format
I have this in a TextBox
I need ##.##%
And the Answer via TEK-TIPS is . . .
=( Avg([ListPrice])-Avg([ClosePrice]) )/Avg([ClosePrice])
This made it all work.
Hope it helps you.