IF statements in Reports

Follow

Richard Thorne

14 January 2014 14:53

Is it possible to use IF statements within formula columns a report?

0

• 

  Colin Kippin 16 January 2014 11:35

  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

   

  0

  Comment actions Permalink
• 

  Colin Kippin 16 January 2014 14:19

  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

   

  0

  Comment actions Permalink

Please sign in to leave a comment.