9 Replies Latest reply: Jan 31, 2014 10:40 AM by Srikanth Narasimhan RSS

    Help with debugging script

      I have the following script snippet:

      ...

      [RefEngy1]:

      LOAD

      Month,

      ContractYr1Pctg,

      Capacity

      ...

      [RefEngy]:

      LOAD

      Month,

      if (Month = 'Jan', ContractYr1Pctg*Capacity, 'No Value') as [Ref Energy]

      Resident RefEngy1;

       

      The script  loads fine, and displays a value of 'Jan' for Month and has values for the other fields, but Ref Energy is showing as '-' in the TableBox. Even if the month is anything other than Jan, I should see 'No Value' in Ref Energy??

      Appreciate any ideas

       

      Thanks