I am trying to convert an attribute on the customer record to a double
when it appears on a GI so that the data can be sorted with it. I have tried using the formula editor and using the convert formulas, but the don’t seem to work. I get an error saying “Error: The virtual field SALES2020_Attributes cannot be used in a condition expression.”, SALES2020_Attributes being the name of the text attribute.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/5b38eecb-00e3-4d91-a1ea-2747b9da2299.png)
This is what the formula looks like in the formula editor:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/d652eacd-1a4a-400b-b8e4-95874844b8d7.png)
Any help would be appreciated!
Best answer by Naveen Boga
View original