Skip to Content
0
Former Member
Jan 04, 2008 at 11:17 PM

How to convert MS Access expression in CR

24 Views

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