0

IF Statement based on Report Option

Andrew Rowland

September 05, 2025 16:27

None

Follow

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Andrew Rowland September 05, 2025 16:30

  We have a report that has an IF statement currently hard coded with a distance:

  =NP("Formula","=IF([@[Distance]]<8, ""true"", ""false"")")

  Ideally we would like to offer the ability to enter this as a user Report Option when the report is run.  Is this possible?

• 0
  
  Marc January 06, 2026 13:00

  Hi Andrew,

  Yes, this should be possible.

   

  I'm assuming you don't have any Options set up at the moment, so edit these references as you need.

   

  1. Insert a new line at row 3
  2. In the new A3 type the word Option
  3. In cell B1 type Title
  4. In cell C1 type Value
  5. In cell B3 type your search word/term: Bespoke distance to search against
  6. Change your NP formula to:

     =NP("Formula","=IF([@[Distance]]<$B$3, ""true"", ""false"")")

  7. Make sure your NL("Table") includes the NP formula cell
  8. Press Run

   

  You will now receive a pop-up asking you to enter a particular distance length.