Skip to main content
Question

Error: The virtual field cannot be used in a condition expression.


Forum|alt.badge.img

Added this formula in the generic inquiry 

This error appears when trying to view generic inquiry. not sure what does this error means

4 replies

deebhane
Semi-Pro I
Forum|alt.badge.img+1
  • Semi-Pro I
  • 62 replies
  • January 25, 2022

Hi @jechang 

Can you try with SalespersonID instead of salespersonID _ description. 

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


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • January 25, 2022

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!!


Forum|alt.badge.img
  • Author
  • Freshman I
  • 17 replies
  • February 7, 2022

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.

 


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • February 7, 2022

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

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings