Comments

2 comments

  • Avatar
    Colin Kippin

    Hi Richard,

    Yes you can use IF Statements in reports in the same way as you construct them in documents.

    They do not need the ## at the beginning or the ## at the end of the statement as you do in documents though.

    There are no special restrictions in what what you can do outside of normal IF statements - you can find the question names by opening the field with the normal [ and then starting to type the question name.

    The maximum length of a statement is 8000 characters

    An example may look something like this - here we are using the Yes/No Question to set the figure shown in the report column as either £10,000,000 or £0

    IF([ELRequiredYesNo]="Yes","£10,000,000","£0")

    Hope this helps

     

    Regards

    Colin

     

  • Avatar
    Colin Kippin

    Hi Richard,

    There is also an item in our on line help guide that will help you.

    You can find this here ;

    http://help.schemeserve.com/index.php?title=Formula_Columns

     

    Regards

     

    Colin

     

Please sign in to leave a comment.