Solved

Switch Formula on report designer

  • 31 January 2024
  • 2 replies
  • 64 views
T
Rank
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

dcomerford
Rank
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

Dermot Comerford
Sagar Greytrix
Rank
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 

Sagar Gadge Team Lead - Acumatica O: +91-22-67687800 E: sagar@greytrix.com

Reply


Terms & ConditionsCookie settings
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