MSGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

### Use of Parntheses in Expressions

• Follow

```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?
--
Thank you for your help and support
```
 0
Reply Utf 6/6/2010 11:49:14 PM

```Try this --
Sum(IIf([Mapping].[Pricing]="CPM",[TPImpressions]/1000*[Mapping].[Price],IIf([Mapping].[Pricing]="CPC",[TPClicks]*[Mapping].[Price],[TPConv]*[Mapping].[Price])))*[Mapping].[Eye Engage Cost]

--
Build a little, test a little.

"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?
> --
> Thank you for your help and support
```
 0
Reply Utf 6/7/2010 3:02:38 AM

```The following gave me an error saying "You tried to execute a query that does
not include the specified expression"
--
Thank you for your help and support

"KARL DEWEY" wrote:

> Try this --
> Sum(IIf([Mapping].[Pricing]="CPM",[TPImpressions]/1000*[Mapping].[Price],IIf([Mapping].[Pricing]="CPC",[TPClicks]*[Mapping].[Price],[TPConv]*[Mapping].[Price])))*[Mapping].[Eye Engage Cost]
>
> --
> Build a little, test a little.
>
>
> "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?
> > --
> > Thank you for your help and support
```
 0
Reply Utf 6/7/2010 5:19:58 AM

```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?
```
 0
Reply John 6/7/2010 12:59:56 PM

3 Replies
382 Views

(page loaded in 0.088 seconds)

8/21/2012 3:20:43 AM