Hi, @jechang Hoping that FLXProject is your custom ? Can you please share the XML format of this GI.

hi @Naveen B, 

I have joined the tables in the GI.

as shown in the screenshot below, the first three works. but when I apply the IIF() Function, I will still face the Error: The virtual field SalespersonID_description cannot be used in a condition expression.

Hi, @jechang  Virtual fields we can not use in GI formulas.

If you want to use those fields in formulas, you need to bring these fields from the Main DAC but not reference DAC.

In the above GI, you need to join the SalesPerson table (using SalesPersonID condition) and use the SalesPerson fields in the formulas.

Hope this helps!!

Hi @jechang 

Can you try with SalespersonID instead of salespersonID _ description. 

If you still facing issue, please share the GI in xml format.