For Help

Viewing 2 reply threads
  • Author
  • July 29, 2019 at 2:07 AM #36097

    talal alotaibi


    I wish everyone a happy day

    How to use a tool larger than or smaller than with a replacement


    if X>Y print “No balance”

    Can I do it through the calculator
    Or should be placed in a script

    If you put it in a script, add it in the form

    July 29, 2019 at 6:54 PM #36108

    Sam Moffatt

    This is a calculation field but if you want to put text, you have to change the return type of the calc field from numbers to text. Something like this should work:

    IF([Balance In]> [Balance Out];[Balance In]-[Balance Out];"No Balance")

    You must be logged in to view attached files.
    July 30, 2019 at 4:06 AM #36114

    talal alotaibi

    It works well Thank you so much

    all respect to you

Viewing 2 reply threads

You must be logged in to reply to this topic.