5 Replies Latest reply: Apr 12, 2012 12:44 AM by Sumit Thakur RSS

    Please help

      I am trying out this expression in my script ,but it is not working...

       

      Calculation:

      Load

      if(bilunit=2, sum(losalrate*loaactwt*1000)) as A,

      itemproduct

      Resident loadingchallan

      Group by itemproduct;

       

       

       

      But while reloading it show this error

       

      Field not found - <losalrate>

      Calculation:

      Load

      if(bilunit=2, sum(losalrate*loaactwt*1000)) as A,

      itemproduct

      Resident loadingchallan

      Group by itemproduct

       

       

      I have also try the another expression

       

      Calculation:

      Load

      if(bilunit=2, losalrate*loaactwt*1000) as A,

      itemproduct

      Resident loadingchallan

      Group by itemproduct;

       

       

       

      the error mess occur as

       

      Aggregation expressions required by GROUP BY clause

      Calculation:

      Load

      if(bilunit=2, losalrate*loaactwt*1000) as A,

      itemproduct

      Resident loadingchallan

      Group by itemproduct

       

       

      so please help me out