Switch Formula on report designer

  • 31 January 2024
  • 2 replies

Userlevel 1

Please assist, I am trying to use the switch formula on the report design, but i get an error when validating the formula. I don't know what i am missing. 




Best answer by dcomerford 31 January 2024, 10:32

View original

2 replies

Userlevel 7
Badge +12

Try changing the “ to a single inverted ‘ around the Text and try it. You can also remove the ‘ commas from the 1, 2, 3 also but that should not make any difference

Userlevel 5
Badge +1

Hi @TitileGama ,

@dcomerford is correct, I am using below formula and able to validate successfully.

Switch( [CashAccountPaymentMethodDetail.DetailID]= 1,'Account Nbr',[CashAccountPaymentMethodDetail.DetailID]= 2,'Account Type',[CashAccountPaymentMethodDetail.DetailID]= 3,'Branch Code')





About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved