Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Check with this
Calculation:
Load
sum(losalrate*loaactwt*1000) as A,
itemproduct
Resident loadingchallan where bilunit=2
Group by itemproduct;
it is showing the error
Field not found - <losalrate>
Calculation:
Load
sum(losalrate*loaactwt*1000) as A,
itemproduct
Resident loadingchallan where bilunit=2
Group by itemproduct
Hi,
Then check you have field losalrate in the table loadingchallan.
Also check whether it is in same case.
Celambarasan
Is there a field "losalrate" in the table "loadingchallan"?
sorry there was spelling mistake...
Thank u for ur help