Line loop with multiple conditional results, syntax not working

Maarten Houtman

• May 31, 2024 12:07
• Edited

I created a line loop with a conditional that basically checks a column value 'Y' or 'N' (checkbox).

IF($[$230000040.234000016.0] = 'Y' AND $[$230000040.230000017.NUMBER] > 0)

BEGIN

SELECT 'RUN' FOR BROWSE

END

IF($[$230000040.234000016.0] = 'N')

BEGIN

SELECT 'PASS' FOR BROWSE

END

So I created 2 result lines for both 'RUN' and 'PASS' to simply count a single column.

Now I want to use the dynamic syntax for both conditionals using $[LLRESULT.COLNAME.NUMBER]. However, when I enter for example $[LLRESULT.RUN.NUMBER] it gives an invalid keyword error.

Can someone tell me what I am doing wrong? What is supposed to go into the "COLNAME" part?

This syntax has been available since 2017 from what I can find.

B1UP version: B1 Usability Package 2023.08

Vote

1

• 

  Geoff Booth

  • May 31, 2024 15:52

  Try Changing $[LLRESULT.RUN.NUMBER]  to $[LLRESULT.RUN.TEXT] 

Please sign in to leave a comment.