firestorm998
Registered User.
- Local time
- Yesterday, 19:37
- Joined
- Nov 28, 2006
- Messages
- 24
i'm using the following expression in an Append query and have recently had to had another IIF for a new product type in the 'Product Type' field.
Base Gross Notional-Short: IIf([long/short]<>"Long",IIf([contract sizeb]="Equity (Incl Options)",([gross equity exposure]),IIf([product type]="BondOption",([MARKET_VALUE_CLEAN(BASE)]),IIf([product type]="FutureBond",[notionalpar]*100000*[fx rate]*[price]/100,IIf([product type]="Futurecommodity",[notionalpar]*[future contract size]*[fx rate]*[price],IIf([product type]="Fxoption",[MARKET_VALUE_CLEAN(BASE)],IIf([product type]="Structuredproduct",[MARKET_VALUE_CLEAN(BASE)],([notionalpar]*[fx rate]))))))))
The item causing the error the "FXOption" product type. I can successfully reference the [Product Type] field and the [Market_Value_Clean(Base)] together in my IIF for "Bondoption" so I'm confused why i can't reference the same fields for the "FXOption" IIF???
Base Gross Notional-Short: IIf([long/short]<>"Long",IIf([contract sizeb]="Equity (Incl Options)",([gross equity exposure]),IIf([product type]="BondOption",([MARKET_VALUE_CLEAN(BASE)]),IIf([product type]="FutureBond",[notionalpar]*100000*[fx rate]*[price]/100,IIf([product type]="Futurecommodity",[notionalpar]*[future contract size]*[fx rate]*[price],IIf([product type]="Fxoption",[MARKET_VALUE_CLEAN(BASE)],IIf([product type]="Structuredproduct",[MARKET_VALUE_CLEAN(BASE)],([notionalpar]*[fx rate]))))))))
The item causing the error the "FXOption" product type. I can successfully reference the [Product Type] field and the [Market_Value_Clean(Base)] together in my IIF for "Bondoption" so I'm confused why i can't reference the same fields for the "FXOption" IIF???
