Solved

Switch Formula on report designer

  • 31 January 2024
  • 2 replies
  • 85 views

Userlevel 1
Badge

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. 

 

 

icon

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')

 

Regards,

Sagar 

Reply


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