If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Use of Parntheses in Expressions
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 |
#2
|
|||
|
|||
Use of Parntheses in Expressions
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 |
#3
|
|||
|
|||
Use of Parntheses in Expressions
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 |
#4
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|