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 
Ads 
#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 20022005, 20072010 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  

