5 Replies Latest reply: Feb 14, 2018 3:22 AM by Frank Lepper RSS

    Variable not set in script

    Frank Lepper

      I try to get a Load with a where condition like

       

       

      LOAD 
      field1,
      field2
      Fractile(field3,0.95) as field3_95
      Resident
      LP_Transactions
      where
      field1 = $(LastRun)
      group by field1,field2;

       

      LastNum can be drawn earlier in the script from

       

       

      LOAD Distinct
      run
      Num
      Resident
      LP_Runs;

       

      I try to get it into a variable like this:

      Let LastRun = max(runNum);

      But I never get "LastRun" filled.

      In my dashboard I easily can get the correct number. into a text field.

      Any suggestions?

      tx Frank