Skip to main content
Solved

Switch Formula on report designer

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

View original
    Did this topic help you find an answer to your question?

    2 replies

    dcomerford
    Captain II
    Forum|alt.badge.img+15
    • dcomerford
    • Captain II
    • 646 replies
    • 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
    1 person likes this
    • Chris Hackett
      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
    2 people like this
    • Chris Hackett
      Chris Hackett
    • dcomerford
      dcomerford

    Reply


    Most helpful members this week

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie 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