Please help

[#1]

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

[CELAMBARASAN]

Hi,

     Check with this

Calculation:

Load

sum(losalrate*loaactwt*1000) as A,

itemproduct

Resident loadingchallan where bilunit=2

Group by itemproduct;

[#3]

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

[CELAMBARASAN]

Hi,

     Then check you have field losalrate in the table loadingchallan.

     Also check whether it is in same case.

Celambarasan

[Anonymous]

Is there a field "losalrate" in the table "loadingchallan"?

[#6]

sorry there was spelling mistake...

Thank u for ur help