Problem with Expression Box formula - InfoPath Dev
in

InfoPath Dev

Problem with Expression Box formula

Last post 01-29-2009 09:29 PM by swathip. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 01-29-2009 08:53 AM

    • clawrence
    • Top 500 Contributor
    • Joined on 11-07-2008
    • Birmingham, AL
    • Posts 38

    Problem with Expression Box formula

    I can't get a formula I'm putting into my expression box to work.

    If I put it in like this xdMath:Eval(., "@Quantity - @LowestCompetitivePrice/@LowestCompetitivePrice") it works, but that's not how I want the formula to work.

    I want this: xdMath:Eval(., "(@Quantity - @LowestCompetitivePrice)/@LowestCompetitivePrice"), but as soon as I put those paretheses in, I get the following error:

    msxml5.dll
    Expression must evaluate to a node-set.

    -->(@Quantity - @LowestCompetitivePrice)<--/@LowestCompetitivePrice

    Error occurred during a call to property or method 'Eval'.

    Can anyone help?

  • 01-29-2009 05:54 PM In reply to

    Re: Problem with Expression Box formula

    I think the '/' is being misinterpreted. Put a space between @LowestCompetitivePrice) / @LowestCompetitivePrice like so...

    Hilary Stoupa

  • 01-29-2009 09:29 PM In reply to

    Re: Problem with Expression Box formula

    Hi,

     

    Try the following expression.

     xdMath:Eval(., "(@Quantity - @LowestCompetitivePrice) div @LowestCompetitivePrice")

     

    Swathip
    www.ggktech.com
Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.