logical expression in calculation - InfoPath Dev
in

InfoPath Dev

logical expression in calculation

Last post 03-30-2011 01:26 AM by Jimmy. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 03-29-2011 10:07 PM

    • ilya.mim
    • Not Ranked
    • Joined on 10-18-2008
    • Russia
    • Posts 8

    logical expression in calculation

    Hi,

    I have a repeating table which contains costs. I have to calculate a total cost. I use sum function.

    But some rows can contain a symbol "-". Sum function returns "NAN" in this case/

    Can I use some logical expression to check a value of control and return "0" if the value is "-"?

     

  • 03-30-2011 01:26 AM In reply to

    Re: logical expression in calculation

    This expression should work:

     translate(number(field), 'Na', '0')

    Jimmy Rishe / Software Developer / Microsoft MVP
    Qdabra Software
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.