pdvsa
asked on
Sum help
Experts,
I have a calculated field in the control source of a report:
USD Equivalent: IIf([tblCurrencyExchange]. [CurrencyI D]=1,"",Fo rmat(([tbl FXRates]![ Amount]*[t blCurrency Exchange]! [ExchangeR ate]),"Cur rency"))
I need to sum this USD Equivalent but for each [projects].[ID]
I have an idea how to do it but something is not correct.
I can not sum it on the report face (doesnt allow since it is calculated)...need to sum in the query design window.
thank you...let me know if you need additional info.
I have a calculated field in the control source of a report:
USD Equivalent: IIf([tblCurrencyExchange].
I need to sum this USD Equivalent but for each [projects].[ID]
I have an idea how to do it but something is not correct.
I can not sum it on the report face (doesnt allow since it is calculated)...need to sum in the query design window.
thank you...let me know if you need additional info.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Or possibly this, and do the formatting through the textbox properties instead of in the expression:
= SUM( ABS([tblCurrencyExchange].[CurrencyID]=1) * [tblFXRates]![Amount]*[tblCurrencyExchange]![ExchangeRate])
ASKER
thanks. It works.
Glad to help and thanks for the points.
ET
ET
Open in new window