Skip to main content
Answer

Switch Formula on report designer

  • January 31, 2024
  • 2 replies
  • 354 views
T
Jr Varsity II
Forum|alt.badge.img

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

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

    2 replies

    dcomerford
    Captain II
    Forum|alt.badge.img+15
    • dcomerford
    • Captain II
    • Answer
    • January 31, 2024

    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
    Chris Hackett
    Sagar Greytrix
    Captain II
    Forum|alt.badge.img+3

    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
    Chris Hackett
    dcomerford
    Terms & ConditionsCookie settingsAccessibility statement
    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