Post Author: marilourlb@yahoo.com
CA Forum: Formula
Hi,
I was wondering if the following MS Access expression can be converted in CR and if so, where can I do this? I tried within a formula but can't get it to work.
RVU as: IIf(IsNull([RVU by EAP].[RVU]),(SELECT [RVU by EAP].RVU FROM [RVU by EAP] WHERE ((([RVU by EAP].EAP)=[CLARITY_HSP_TRANSACTIONS].[PROC_ID]) AND (([RVU by EAP].[Cost Center ID]) Is Null))),[RVU by EAP].[RVU])
Thanks