View Single Post
  #4  
Old June 7th, 2010, 01:59 PM posted to microsoft.public.access.queries
John Spencer
external usenet poster
 
Posts: 7,815
Default Use of Parntheses in Expressions

Breaking that all down and formatting it for readability, I think you could
use the following expression.
Sum(
IIf(
[Mapping]![Pricing]="CPM",
[TPImpressions]/1000*[Mapping]![Price],
IIf(
[Mapping]![Pricing]="CPC",
[TPClicks]*[Mapping]![Price],
[TPConv]*[Mapping]![Price]
)
)
*[Mapping]![Eye Engage Cost]
)

If that errors, perhaps you could post the SQL statement of the query. (Menu -
View: SQL, copy and paste.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

bbal20 wrote:
Hello,

I am fairly new to Access and Excel. I am trying to write a
formula/expression, but I think my problem is as simple as having the
parenthese in the wrong place. The formula I have currently is as follows:

Sum(((IIf([Mapping]![Pricing]="CPM",[TPImpressions]/1000*[Mapping]![Price],IIf([Mapping]![Pricing]="CPC",[TPClicks]*[Mapping]![Price],[TPConv]*[Mapping]![Price]))))*[Mapping]![Eye Engage Cost])))))

I basically want the SUM(IF part to be evaluated first and then multiply the
result by [Mapping]![Eye Engage Cost] at the end. Currently, the formula
above returns the value in the Sum(IF, but doesn't mulitply by the Eye Engage
Cost.

Also, can anyone reccomend a website or good reference materail that will
help me understand how parentheses work in Nested Formulas other than knowing
that the innner most parentheses is always evaluated first?